Date functions in ASP

[martin de vroom]

ISDATE(...)

or if you want to find the last day of the current month,

set the date to the first, add one month using dateadd, minus 1 day.

cheers

martin.

"Tim Johnson" <timj@smithscity.co.nz> wrote in message
news:070a01c345cc$f9312ba0$a501280a@phx.gbl...

> I was wanting to know if there is a function in ASP that
> is able to check if a date is valid or not. I know the
> IsDate function, but its not (I think) quite what I'm
> after.
>
> I have 3 drop down boxes on my page - Month/Day/Year. Is
> there a function that would check "31 Febuary 2003" - and
> tell me that this is an invalid date?
>
> TIA.

[Bob Barrows]

Tim Johnson wrote:

> I was wanting to know if there is a function in ASP that
> is able to check if a date is valid or not. I know the
> IsDate function, but its not (I think) quite what I'm
> after.
>
> I have 3 drop down boxes on my page - Month/Day/Year. Is
> there a function that would check "31 Febuary 2003" - and
> tell me that this is an invalid date?
>
> TIA.

You can use DateSerial and catch the error when it's given an invalid date.

A better strategy is to not allow an invalid date to be selected in the
first place. It's pretty simple to write a sub that reloads the Day dropdown
with the valid days for the month and year combination in the onchange
events of those dropdowns. Give it a try and if you get stuck, ask for help
on a client-side scripting newsgroup such as m.p.scripting.vbscript or
m.p.scripting.jscript (or find a newsgroup with dhtml in its title)

HTH,
Bob Barrows

[Aaron Bertrand [MVP]]

Please don't multipost. What does this have to do with databases?





"Tim Johnson" <timj@smithscity.co.nz> wrote in message
news:070a01c345cc$f9312ba0$a501280a@phx.gbl...

> I was wanting to know if there is a function in ASP that
> is able to check if a date is valid or not. I know the
> IsDate function, but its not (I think) quite what I'm
> after.
>
> I have 3 drop down boxes on my page - Month/Day/Year. Is
> there a function that would check "31 Febuary 2003" - and
> tell me that this is an invalid date?
>
> TIA.

[Tim Johnson]

You are exactly right, it has nothing to do with
databases, my intention was not to multi-post but when I
posted the below I didn't realise I was in DB and to my
knowledge there is no way to remove a post?

>-----Original Message-----
>Please don't multipost. What does this have to do with

databases?

>
>
>
>
>
>"Tim Johnson" <timj@smithscity.co.nz> wrote in message
>news:070a01c345cc$f9312ba0$a501280a@phx.gbl...

>> I was wanting to know if there is a function in ASP

that

>> is able to check if a date is valid or not. I know the
>> IsDate function, but its not (I think) quite what I'm
>> after.
>>
>> I have 3 drop down boxes on my page - Month/Day/Year.

Is

>> there a function that would check "31 Febuary 2003" -

and

>> tell me that this is an invalid date?
>>
>> TIA.

>
>
>.
>