1 of 1 people found this helpful
if both the dates are coming from different fields the link might be helpful
Michael Thank You for reponsinding. My mistake I didn't post right question. So here is my scenario
I have a case where I need to find if Failure date > 15 min then "A" else "B".
I have some cases, so this is one if the case
Failure date is the image which was posted with question. SO, Im trying to find out the minutes between current time and Failure time. SO, if the difference between these two is less then 15 minutes then its active.
So, Im getting current time by using NOW function and it returns me the value. IS there a way you could provide solution for this Thank You
Thanks for explanation. The calculation should be:
IF DATEDIFF('minutes',[Failure date],today())>15 THEN 'A' ELSE 'B' END