Date Problem - DPART

[mccrimmon]

Hi

Im hoping someone can help.

I have the following code, however, I am getting an unexpected result.

FullDate is coming in as a string value of 40716.
When converted using the CDate function it is correctly showing as 22nd June 2011.

However, the problem seems to be with strDateMonth. This is showing as Jan rather than June when going through the format?

Can anyone help?

Seems bizarre.

Please Login or Register  to view this content.

Thanks

McC

[watersev]

the problem is in Format function, this works as it should:

Please Login or Register  to view this content.

[Leith Ross]

Hello McCrimmon,

The problem lies with how "DartPart" returns the month. It does not return the month name as "Jun", "Jul", etc, but as a number. January is 1, February is 2, etc. You can skip using the "DatePart" for the month and use just the format statement. You can then format the month as the short or long form.

Please Login or Register  to view this content.

[snb]

Why not using VBA ?

Please Login or Register  to view this content.