Finding all records from last 48 hours.

[HollidaySlim]

If this is in the wrong spot I apologize and if a mod could move it I would appreciate it.

Hello all,

I am trying to find a way to view all the records I created in the last 48 hours/24 hours/and that day. I tried to create a report that would do it but had no luck. I am really at a lost as how to do this. Any help on this would be awesome!

Thanks!

[Lee Smith]

Create a TimeStamp Field, and have it Auto Fill with Record Creation.

You can then set up a find based on this field.

Lee

[HollidaySlim]

Thanks for the reply Lee.

Re-reading my OP, I guess I left some crucial detail out (sorry about that ) . I ultimately want to have this automated. IE. I click on a button and it will display a report or new layout with the records I have created in the last 48 hours and their information. I thought doing a report would achieve this but I could not find a way for it to constrain the records to only the ones created in the last 48 hours. I have attached a copy of my file maker database so whoever can see what i am working with.

Leads_V1.2_Copy04212009.zip

Edited April 21, 2009 by Guest

[Lee Smith]

Try a scrip like;

Enter Find Mode [ ]

Set Field [ Leads::Date Created; Get ( CurrentDate ) -2 & ".." & Get ( CurrentDate ) ]

Perform Find [ ]

[HollidaySlim]

Thanks Lee! That should work out great.