Time stamp calculation Queston 1

[Reynet01]

I have a field with a Date/time I would like to build a lookup parameter by that field such so client can enter a number of hours and it show and record that is older than the number of hours entered, such as if the client enters 12 hours it will show all records that are 12 hours or older. Any help would be appreciated.

Rob

 

[lbass]

Try using a record selection formula like:

datediff("h", {table.datetime},currentdatetime) > {?hours}

-LB

 

[Reynet01]

Thanks That worked Like a Champ!

I appreciate the help