Date ranges with ASP

[mschmidt18]

Hello,

I have a field in my Access table with a Date type. The dates are
stored as "mm/dd/yyyy" in the table (well thats how it appears when i
open the table). on my ASP page i want to pull all records that have
todays date or later. I'm not sure how to do this because the date
appears in full date format when i view it with ASP. Any words of
wisdom or good examples to view? All help is appreciated. I am using
javascript as my ASP language if that matters.

Thanks,
Matt

 

[John Vinson]

Hello,

I have a field in my Access table with a Date type. The dates are
stored as "mm/dd/yyyy" in the table (well thats how it appears when i
open the table).

That's only its appearance. It's actually stored as a double float
Number, a count of days and fractions of a day (times) since midnight,
December 30, 1899.

on my ASP page i want to pull all records that have
todays date or later. I'm not sure how to do this because the date
appears in full date format when i view it with ASP. Any words of
wisdom or good examples to view? All help is appreciated. I am using
javascript as my ASP language if that matters.

Use a Query with a criterion

= Date()

John W. Vinson[MVP]