Date in VBA

[witek]

Hi guys.

I have three variables, day, month and year.

How to create a valid date from them.

CDate needs expression, but it depends on regional settings, so
CDate ("5/6/2006") will return May 6th, or June 5th depends on settings.

I need something more universal.
Does it exist?

 

[Jim Thomlinson]

Try DateSerial something like this...

MsgBox DateSerial(2005, 5, 6)

 

[witek]

Try DateSerial something like this...

MsgBox DateSerial(2005, 5, 6)

Yes, Thanks.