IsDate date format

  • Thread starter Sebastian Santacroce
  • Start date
S

Sebastian Santacroce

Hi,
I am trying to use IsDate where the application will use a
format of Month/day/year however on a system that uses
day/month/year then IsDate uses that system format setting
when evaluating if its a valid date. I want IsDate to use
Month/Day/Year when validating and so independently from
the system date format. How can I do this?

Thanks,

Seb
 
H

Herfried K. Wagner [MVP]

* "Sebastian Santacroce said:
I want IsDate to use
Month/Day/Year when validating and so independently from
the system date format.
Click to expand...

Use 'Date.ParseExact' insead + a 'Try...Catch' exception handler.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date conversion problem 4
How do I calculate the date of the previous day given a date ( in "MM/dd/yy" format) 2
Excel Vba to change displayed year automatically. 14
Date format 4
TextBox Validation for time only, not date 9
Excel VB - Testing Month within a blank cell 7
conditional format -- if not a date, then highlight cell 1
Isdate, checking Formatting too e.g. dd/mm/yyyy 2

Top