Forum Discussion
Solved
Creating an entry based upon a date compared to today
I have a status collumn that populates based upon a date column. It works great except for the highlighted portion. What I need to happen if the Approved Date field is blank and today is later than...
It would be helpful next time (or if this doesn't work) to include some sample data to work with.
The order matters with these statements, so try this instead.
Status Approval = SWITCH ( TRUE (), ISBLANK ('Execution Status'[Approved Date].[Date]) && ('Execution Status'[Due Date].[Date]) < TODAY (), "Overdue", ISBLANK ( 'Execution Status'[Approved Date].[Date] ), "In Process", 'Execution Status'[Approved Date].[Date] < 'Execution Status' [Due Date].[Date], "On Time", "Completed Late" )
That did the trick. Thank you so much for your help. Still trying to learn all of this.
Happy to help.