I have a SharePoint list of devices that are checked out or reserved by a personnel. We check them out or reserve them based on the requested dates that has a start date to finish date column.
How would I go about displaying in a new column called status a Green Image for Active and Yellow for upcoming? I would like this to dynamically update based on the dates provided.
So that for example a reservation date of 08/06/2014 - 08/09/2014 is displayed in green for Device #1. Then another reservation for the same device with the dates of 08/10/2014 08/15/2014 is displayed in yellow.
Once the green reservation end date is passed it will change to red for inactive and then we can delete it.
Is this possible or would a Nintex workflow be better suited for this?
Just look for some direction or a small example not a full solution.