Skip to Content
avatar image
Former Member

Breaking down a datetime

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 21, 2016 at 07:53 AM

    Hi Paul,

    Try:

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

    'Walk-in'

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded