AnsweredAssumed Answered

Display an Image based on date range

Question asked by deaconf19 on Aug 7, 2014
Latest reply on Aug 8, 2014 by deaconf19

Currently I have a workflow that parses an XML file and then creates a new list item. The XML data is from a form that is a reservation system for devices in our inventory. Sometimes one device can be marked active and upcoming based on the dates provide by requestors.

 

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 for example a reservation date of 08/06/2014 - 08/09/2014 is displayed in green (Active) for 0001. Then another reservation for the same device with the dates of 08/10/2014 08/15/2014 is displayed in yellow (upcoming). Once the green reservation end date is passed it will be removed from the list since it will be deemed in active and the upcoming will change to green.

 

Start dateEnd DateStatusDevice
08/06/201408/09/2014Active0001
08/10/201408/15/2014Upcoming0001

.

I hope this makes sense and is feasible.

Outcomes