Pl attach some fake data
1 of 1 people found this helpful
U need to write logic like below:
if [rec due date]>Today() and status='C' then 'still have time'
elseif [rec due date]<=Today() and status='C' then 'time Passed'
Hope this helps.
thank you so much
Glad that helped you
Please mark the answer as correct to close the thread.