Selection Formula 1

[mrichey]

I'm trying to select all records where the date field is in the period of yesterday, or the last 24 hours. The select expert provides canned selects for in the period of last full week, month, year, etc. but not for the prior day.

Any thoughts on how I can easily do this? Thanks!!!

 

[synapsevampire]

{Table.Datefield} = currentdate-1

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com