How to calculate the previous day?
 

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

How to calculate the previous day?
 

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

How to calculate the previous day?
 

Hi,

Thanks for the answer. Just one more help. I have just started using
VBA on excel (had done AS400 programming for 7 years). But now totally
into Excel VBA. So programming is not a problem. Can you recommend any
book or any website that contains example codes. My job here is to
basically use/work on a master sheet in main workbook and populate
detail sheets either in the main workbook or a different workbook. I
want to start working on VBA properly and on the track.
regards,
Prasad Vanka



"Tom Ogilvy" wrote in message ...
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

How to calculate the previous day?
 

Go to this site and download the Google add-in
www.rondebruin.nl/Google.htm

It is better than a single site or book.

--
steveb
(Remove 'NOSPAM' from email address if replying direct)


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

Thanks for the answer. Just one more help. I have just started using
VBA on excel (had done AS400 programming for 7 years). But now totally
into Excel VBA. So programming is not a problem. Can you recommend any
book or any website that contains example codes. My job here is to
basically use/work on a master sheet in main workbook and populate
detail sheets either in the main workbook or a different workbook. I
want to start working on VBA properly and on the track.
regards,
Prasad Vanka



"Tom Ogilvy" wrote in message
...
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