Skip to main content
Question

Setting a Field value based on a Date/Time Field

Forum|alt.badge.img+9
I am trying to right a formula that will compare two Date/Time fields and set the text formula fields value based on the two values.  For example, if the first Date/Time field is set to "05-17-2022 12:00 AM" and the second Date/Time field is set to 05-17-2022 12:30 AM, I want the Formula Text field label to be set to "On time".  The rule for this value would be 30 minutes before and 30 minutes after the first Date/Time field.  If the second Date/Time field is outside of 30 minutes after the first Date/Time field, or more than 1/2 hour after, label should be "Late".

Thanks

------------------------------
Brian Dunk
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+20
Untested by try:

If(
 [Date Time Field 2] > [Date Time Field 1] + minutes(30) or  [Date Time Field 2] < [Date Time Field 1] - minutes(30), "Late", "On time")

------------------------------
Mike Tamoush
------------------------------
Terms & ConditionsAccessibility statement