Hi All,
Need your help in the following issue:
Please how can I get the difference between two dates should not more than 24 hrs?
For example 1 :
Start Date = 7/1/2024 12:00 AM EST
End Date = 7/1/2024 11:59 PM PST
if user enter the above dates and time than Don’t allow to select since the difference is > 24 hours
Thank you in advance for your help!
Discussion posts and replies are publicly visible
Just subtract the dates use hour() functions to check whether difference between the dates is greater than your requirement
this might help with some logic to get you started ...
a!localVariables( local!maxTime: addhours(ri!startTime,24), a!match( value: local!maxTime, whenTrue: local!maxTime < ri!endTime, then: "end time exceeds 24 hours", default: {} ) )
Note this uses this component ...
Date and Time Utilities