Determine cells date format

[ElmerS]

Hi,

How can I determine a cells date format in VBA ?

I want to return TRUE for only one particular format which is: dd/mm/yyyy and FALSE for all! other formats.

dd/mm/yy, dd.mm.yy, dd.mm.yyyy, mm/dd/yy etc, should return FALSE

I have tried:

Please Login or Register  to view this content.

but the Msgbox poped-up even for 23/11/1999

Thanks, Elm

[shg]

Please Login or Register  to view this content.

[ElmerS]

Thank you.

I changed the format while you were replying, so I tried: "dd/mm/yyyy".

Something very strange happens here.

I checked in two different computers and it returns FALSE.

In both computers the 23/11/1999 returns: m/d/yyyy with: MsgBox Range("A1").NumberFormat

Do you think it has to do with it being an European Format - or...?

Elm

[DonkeyOte]

Perhaps:

Please Login or Register  to view this content.

would work for you ?

edit: probably not actually ... it's not a format specific test I guess.

[ElmerS]

Thanks.

No, it does not.

It returns True for: 23.11.1999 as well

Elm

[DonkeyOte]

It returns False for me if running client on Icelandic regional - on which locales are you running this ?

You might also want to investigate NumberFormatLocal property.

Handling dates and date formats is often a PITA in XL.

[pike]

Hi ElmerS,
The spammer title will be reversed - Apologises for the mistake

[ElmerS]

Thanks, DO,

So far so good with NumberFormatLocal.

Hopefully it wont give me unexpected or wrong results in the future.

Elm