simple Q

[rmanchu]

hi

i'm stumped on how to filter a form recordset by date fields

2 date fields "arrivaltime", "expectedtime"

recordset.filter = "(arrivaltime-expectedtime)>=#0:05#"
to filter those who r late by 5 minutes

am using ado v 2.8, with ms sql server 2000

haaalp
thanx
riyaz

 

[smk23]

Riyaz: take a look at this:

http://allenbrowne.com/casu-13.html