Thread: Date in VBA

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?

Try DateSerial something like this...

MsgBox DateSerial(2005, 5, 6)
--
HTH...

Jim Thomlinson


"witek" wrote:

> 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 wrote:
> Try DateSerial something like this...
>
> MsgBox DateSerial(2005, 5, 6)

Yes, Thanks.