Using Date Calculation Formulas - hourly?

delsied

Is there any way to indicate a portion of a day with the Date Formula function? The abbreviations are:
C Current
D Day(s)
W Week(s)
M Month(s)
Q Quarter(s)
Y Year(s)

I use 0D for same day, -14D or -2W for 2 weeks prior, etc.

But now we're trying to set a (cancellation) rule based on time, or number of hours prior to a time set in a record (in our case a reservation).

Any ideas? If not, we'll probably have to do our own programming... but thought I would check this group first. Thanks for any information you can provide on this topic!

kine

you cannot use date formula against time. But you can use DURATION and add/subtract it from time or datetime.

delsied

Thank you for the tip! I'll work with that!