forum.vdsworld.com

jwfv · Posted: Wed Jun 11, 2003 1:21 pm Post subject: Help on valid dates?

I have searched the forum and haven't found this topic. Any help is appreciated:

I have an edit box where the user enters a date. Then, when the data is saved, that date is saved in a database.

How can I check to make sure the date is valid before saving? I could do it either at the time it is saved, or before they exit the edit box.

I can't figure out how to use @datetime() to make sure the date is valid and not something like:

13/14/15

Thanks!

(PS - An alternative solution would be I guess to check that the date is X number of days away from today's date? - The date they will enter should always be within a couple of weeks of today's date .....)

DW · Contributor Joined: 21 Mar 2003 Posts: 175 Location: UK

Im not really sure but couldnt you parse the three sections of the dateand then check it?

Example being, user enters 10/03/03

you could have your program take the days which would be 10, then the month which is 03, and finally the year, also 03.

after cutting up all the sections you could check each one.
Just a suggestion but i think it would work.
Maybe someone round here can show you what I have said in code form.

Hope that helps some.

DW · Contributor Joined: 21 Mar 2003 Posts: 175 Location: UK

Im only a noob but would something like this do it?
Would need better checking routen.

FreezingFire · **Admin Team** Joined: 23 Jun 2002 Posts: 3508

Well I get an exception: invalid date/time error when using this code:

jwfv · Posted: Wed Jun 11, 2003 2:58 pm Post subject: valid date

Thanks for the responses -

Yeah, I could break it up like in your example, DW - I may do that.

I was hoping for an elegant, one-line solution (of course.) But like FF shows in his example, checking @datetime on an invalid date just gives an error right off the bat.

Thanks for the help, though. I may modify the example parsing code and use that, if nothing else comes along.

Serge · Posted: Thu Jun 12, 2003 3:26 pm Post subject:

you could also use 3 drop down boxes (one for the days, one for the months and one for the years)...this way you don't have to worry about checking dates...the down side is that you need to set the number of days depending on the month selected (eg. february)

or you can use 3 spin boxes...

Serge

Tommy · Posted: Sun Jun 15, 2003 8:41 pm Post subject:

Also DLLs exist that have a datetime selection element (VDSOBJ 2?).

jwfv · Posted: Sun Jun 15, 2003 8:48 pm Post subject:

Thanks for all the help. I'm going to look into it and see if the calendar function in that dll will suit my needs.

FreezingFire · **Admin Team** Joined: 23 Jun 2002 Posts: 3508

You can also use edit masking in the VDSOBJ02.DLL Smile