Frank Freese
asked on
Substract 1 day from date()
Experts,
I would like to subtract 1 day from date()
I would like to subtract 1 day from date()
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks...killed 2 birds with one stone.
=DateAdd("d",-1,Now())
Date/Time fields are also simply a double float with the whole number portion represneting the date, so you could also do:
=Now() - 1
But I would use DateAdd() for a number of reasons; it's clearer what's going on, works with every type of period (days, weeks, years, etc) and takes care of the time as well.
JimD.