Dates are stored as the number of days from a base date, so to get the day
before, just subtract 1

dtYesterday = dtMyDate - 1

--
Regards,
Tom Ogilvy


"Prasad Vanka" wrote in message
...
Hi,

I have a date field dtMyDate. Can someone tell me how do I find the
value of the date that is 1 day before dtMyDate?

Also I am still looking for proper answers to the questions I have
posted on the 6th of May 2004.

Thanks in advance
Prasad Vanka