Filtering Records Based on Date/Time

[Jables]

Is there any function to compare dates/times. I want to create a recordset that selects records that have been updated within say the last 24 hours.

My thinking is like this:

User Updates Record
Date/Time Field in DBase is set = Now() or DateValue(Now()) or something like that
A separate page displays a filtered recordset where Date/Time < 24 hours old.

Rock me with your ideas and thanks in advance.

 

[lobstah]

DateDiff(Interval, Date1, Date2, FirstDayofWeek, FirstWeekofYear)

The DateDiff function calculates the amount of time between two different dates.

There are three mandatory arguments.

see

http://www.devguru.com/Technologies/vbscript/quickref/datediff.html

for more info......

 

[Jables]

YES!!!!

Thank you much.