Check if Time is within last hour

[marcin2k]

I have a variable datDate which stores a date and time, so its basically in the format of Now(). I want to check that this time is within 1 hour. How can I do this. I read about the DateAdd function but it seems to always give back a huge number when i subtract Now() from datDate.

Thanks for any help,
Marcin

 

[SkipVought]

Marcin,

How about DateDiff?

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[marcin2k]

i'll give it a try, didn't think of it

 

[marcin2k]

Ya that worked great, do u know by any chance if there is a one liner for changing one data field in a table. Like i know Dlookup looks up what is in a field but I have a table with one Yes/No field and all i have to do is change it to a No. I know i can use RecordSet but trying to think of quicker ways. Thanks

 

[SkipVought]

Use an UPDATE query.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}