0

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!

4
Contributors
4
Replies
6
Views
7 Years
Discussion Span
Last Post by kehar
0

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!

0

Thanks to both of you!

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

0

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.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.