How to check a valid date...
 

Hi everyone!
I have a problem related with dates.... i have some textbox where i put dates to send to a database... i have conditioned the input just for numbers and / (backslash), but how do i check that no one inserts a format that's not dd/mm/yyyy... if i put 1234 sends an error and stops

Thanks everyone!

Re: How to check a valid date...
 

You have to parse each field and check to see if its legitimate.
Also check the day number to number of days in that month.
And double check if its a leap year or not.
You could parse and convert to Julian and store as a 32-bit number.
You may want to consider allowing dwarf entries so that for example today is 6/29/2009 but if someone enter 7/11 it will exchange 7/11 for 7/11/2009 automatically or with a verify! It gets very old having to enter a complete date every time!
You may consider a date split - six months vs + six months so that for example entry of past invoices allows a dwarf date!

Re: How to check a valid date...
 

IsDate anybody???

Good Luck

Re: How to check a valid date...
 

Thanks to both of you!

The IsDate solution works perfectly... of course i'll check the other options, thanks!

Re: How to check a valid date...
 

Add MS Mask Edit control in your form and under its Property go to
mask and enter ##/##/#### then
run the programme and give focus. you can enter your own date without using dtpicker.