Skip to Content
0

Breaking down a datetime

Dec 20, 2016 at 09:13 PM

33

avatar image
Former Member

HI I Have 2 datetimes fields. One is appt_scheduled and the other is appt_confirmed.

I would like to know if the times are within 5 minutes. This would be an indication that the appointment was a 'walk-in' then the formula can display 'walkin' on the row.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Dec 21, 2016 at 07:53 AM
0

Hi Paul,

Try:

IF DateDiff("n", {Appt_scheduled}, {Appt_Confirmed}) <= 5 then

'Walk-in'

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded