records older than 24 hrs (1 Viewer)

[cymrudesign]

i need to make a query that returns all the records older than 24 hrs anyone help me with this one ?

 

[RV]

Can only be done if you explicitly register the date / time the row was created.

RV

 

[cymrudesign]

i have the time inputed when the form is submitted so it is recorded in the row along with the details ......

 

[Michael J Ross]

Using this criteria under your date field should work

<DateAdd("h",-24,Now())

 

[cymrudesign]

may thanks that works a treat ;-)

 

[namliam]

Instead of the (more difficult) dateadd which offcourse works you can also (simply) use
Now() - 1

 

[cymrudesign]

on the same line sortof ..........i have the table entry on the time of the call , how would i go about showing how long ago the call was , i have seen other exapmles of calculating the difference between 2 times ,,,, but in this case i only have one field and it would be recalculated depending on when it was viewed?

 

[namliam]

Use the function Now() for the current date and time.

 

[Michael J Ross]

Create a calculated column using the formula DateDiff("d",[timeofcallfield],Now()), this will show how long ago it was and it will change each time the query is ran.

 

[Michael J Ross]

Create a calculated column using the formula DateDiff("d",[timeofcallfield],Now()), this will show how long ago it was and it will change each time the query is ran.

 

[cymrudesign]

I did try that , but when i run the query it prompts me for an input for the field . im sure its something i have done;-)

 

[Michael J Ross]

Hi,

See attached