This would be easier if you had a Timestamp field, even as a calculation =
Timestamp ( Date ; Time )
Without such field, you will need to create 2 requests: one for records where Date = Get (CurrentDate) and one for records where Date = Get (CurrentDate) -1 and Time > Get (CurrentTime).
This one I didn't understand.
I have created two field called calcD (currentdate -1) and calcT (currentTime) as timestamp, then I created another field CalCombine with your instruction CalCombine(calcD;calcT). I would have the date display as one day before and the time is auto enter as realtime.
I did the same thing as above with a filed call calcurrentCombine; all I have to do is specify the currentdate as current instead -1.
Now I do have value as
Calcombine 2/19/2010 4:00 pm
CalCurrentCombine 2/20/2010 4:00 pm
Thanks again. Is there a shorter way to do this. and how do I trigger this in the script ( my second question).
Capture1.PNG 15.2 K
I am afraid we are not on the same page here. You don't need those calculation fields you have created. You only need a script that does:
Enter Find Mode 
Set Field [ YourTable::Date ; Get (CurrentDate) ]
Set Field [ YourTable::Date ; Get (CurrentDate) - 1 ]
Set Field [ YourTable::Time ; ">" & Get (CurrentTime) ]
Perform Find