IsDate function looking for American Date

**duckboy1981** · 07-20-2009, 10:57 AM

Hey all,

Got a random problem with the IsDate function and was wondering if anybody could help?

Below is the code I am using to check a user input of a date, and if it is a recognised date put it in to a standard format (dd/mm/yyyy). The problem is that VBA is checking for an American format date -

My input - 15/08/09 (15th Aug 2009)
Read as 15th August 2009 and displayed as 15/08/2009, which is correct
But when my input - 07/08/09 (7th Aug 2009)
Read as 8th July 2009 and displayed as 08/07/2009

This could be very problematic, so is there anyway of telling the IsDate function that the standard format is dd/mm/yyyy not mm/dd/yyyy?

Please Login or Register  to view this content.

**romperstomper** · 07-20-2009, 11:10 AM

Format should read the date according to your regional settings. If those are US, then it will assume the date is mm/dd/yyyy originally.

**duckboy1981** · 07-20-2009, 11:19 AM

That was my first thought as well, but all of our terminal servers have the correct regional settings on them.

**romperstomper** · 07-20-2009, 11:36 AM

I can't help you there, I'm afraid. I don't touch TS, Citrix or any of that stuff.

**duckboy1981** · 07-20-2009, 11:42 AM

Not a problem, was just wondering if it was anything within VBA that could be altered to fix it.

**royUK** · 07-20-2009, 11:44 AM

I would not rely on a user's input into a textbox for a date. I use comboboxes to choose from

DateCombos.zip

**romperstomper** · 07-20-2009, 11:45 AM

Nope. VBA functions use your regional settings (except when writing back to a worksheet). No way to change that, so I would have to say something in your TS is not set up correctly.