Hi, in status update I want to return "In Progress", "Not started" and "Completed"
If todays date is greater than End date = "Completed"
If todays date is greater than start date but less than End date = "In Progress"
if todays date is less than start date = "Not started"
Thanks
If todays date is greater than End date = "Completed"
If todays date is greater than start date but less than End date = "In Progress"
if todays date is less than start date = "Not started"
Start Date | End date | Duration | Status |
04-Sep | 25-Sep | 21 | |
04-Sep | 03-Nov | 60 | |
02-Oct | 05-Nov | 34 |
Thanks