DateSerial function

  • Thread starter Thread starter iccsi
  • Start date Start date
I

iccsi

I would like to know is DateSerial function like DateAdd support years
changes when uses month math calculations like followign:


DateSerial(2009, 1-5, 1)

Will DateSerail return 2008/Aug/01?
I know DateAdd returns the above result.

Your information is great appreciated,
 
On Fri, 16 Jan 2009 05:21:27 -0800 (PST), iccsi <[email protected]>
wrote:

Open Access > hit Ctrl+G to open the Immediate window > Enter this:
?DateSerial(2009, 1-5, 1)

And there is your answer.

-Tom.
Microsoft Access MVP
 
iccsi said:
I would like to know is DateSerial function like DateAdd support years
changes when uses month math calculations like followign:


DateSerial(2009, 1-5, 1)

Will DateSerail return 2008/Aug/01?
I know DateAdd returns the above result.
Click to expand...

Sure.

It would be faster and easier for you to just try it than
going back and forth in the newsgroups.
 
Back
Top