Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Multi Format Date Validation 2
- Thread starter cobas
- Start date
-
1
- #2
BiggerBrother
Technical User
Ok, what you want is not impossible, but you have to think about the date 1/2/04. What is this date? IS it 1st Feb or 2nd Jan?? You need to offer your user one way to enter the date, dependant on their regional settings, so if american, it is 2nd Jan and if English, it is 1st Feb. Or you just stick to one date type all the way through the project.
As to valiation, you can use format("dd\/MM\/yyyy", myDate) to change the input to a valid date.
Good luck
BB
As to valiation, you can use format("dd\/MM\/yyyy", myDate) to change the input to a valid date.
Good luck
BB
- Thread starter
- #3
-
1
- #4
I think BB knows this - what he's trying to say is that the first part of validating whether or not something is a date is to understand how the user deals with dates - which depends to a large extent on where in the world they are.
What he's saying is take something like 13/03/2004. If you're in England, that's going to be taken to denote 13th of March, which is quite valid so no problems there... However, if you were in the United States, you would read "13/03/2004" as being the third day in the thirteenth month - which is clearly not a good idea.
Essentially then, whether or not a date value is valid depends very much where you are - and this is why BB has mentioned the locale stuff.
I would recommend that you write code to split out the day, month and year from your date string (remembering to support things like "02/04/2004" and "02-Apr-2004" and "02-April-04"), and then work out from that whether you have a valid date.
The only tricky bit of course is February, because of the leap year having the extra day - which you'll need to allow for in your code.
As a rough guide, if the year is divisible by 4, it's a leap year. If it's divisible by 100 then it's not a leap year, though if it's divisible by 400 it is...
And you're quite right about IsDate - it's a bit of a joke.
mmilan
What he's saying is take something like 13/03/2004. If you're in England, that's going to be taken to denote 13th of March, which is quite valid so no problems there... However, if you were in the United States, you would read "13/03/2004" as being the third day in the thirteenth month - which is clearly not a good idea.
Essentially then, whether or not a date value is valid depends very much where you are - and this is why BB has mentioned the locale stuff.
I would recommend that you write code to split out the day, month and year from your date string (remembering to support things like "02/04/2004" and "02-Apr-2004" and "02-April-04"), and then work out from that whether you have a valid date.
The only tricky bit of course is February, because of the leap year having the extra day - which you'll need to allow for in your code.
As a rough guide, if the year is divisible by 4, it's a leap year. If it's divisible by 100 then it's not a leap year, though if it's divisible by 400 it is...
And you're quite right about IsDate - it's a bit of a joke.
mmilan
- Thread starter
- #5
BiggerBrother
Technical User
Why not do one of the follwoing:
- Use a Date Picker, which gives you a drop down month planner, where you can then select the date you want.
- Create your own control, using two textboxes and a combobox. In the combobox, place all the months, and then place a text box on either side. Only all numeric values in the textboxes, and when the date is entered, the user is forced to enter the date the way you want.
BB
- Use a Date Picker, which gives you a drop down month planner, where you can then select the date you want.
- Create your own control, using two textboxes and a combobox. In the combobox, place all the months, and then place a text box on either side. Only all numeric values in the textboxes, and when the date is entered, the user is forced to enter the date the way you want.
BB
- Thread starter
- #7
- Status
Similar threads
- Locked
- Question
