Hi,
I am trying to prapare a small excep report in which I have four columns.
1. StartDate (will be given and provided)
2. End Date
3. New start date
4. New end date.
now depending on the 4 columns these two columns should be change
1. Status:
2. Tracking:
Conditions:
1. If there are new start date and new end date then Status will be changed to "In Progress" and Tracking will be changed to "Slipped"
2. If there is just start date and end date then Status will be changed to "Complete"" and tracking will be changed to "On Track"
I need to just put status in these 2 column but somehow am not able to put the correct code.
Can some one please help!!
appreciated.
Thanks in advance.
Bookmarks