Jump to content

Find date and time range....


Mac3danim8
 Share

This topic is 7316 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi everyone,

I have a database that has a record creation date and time.

I want to search for records that were created AFTER 3:00 pm yesterday and later.

Question 1- Is there a better field that combines date and time??

Question 2- Should I create a field that combines (somehow) the date and time?

Question 3- How do I search for yesterday? (//-1 or Today-1 don't work in a FIND)

Thanks in advance- This forum is soooo helpful.

Larry

Link to comment
Share on other sites

Try the following steps:

Enter Find Mode []

Insert Text [select, DateField, ">"]

Insert Calculated Result [DateField, "DateToText(Status(CurrentDate) - 1)"]

Insert Text [select, TimeField, ">"]

Insert Calculated Result [TimeField, "15:00:00"]

Perform Find[]

DateField and TimeField should be replaced with your field names. Make sure "select" isn't checked on the Insert Calculated steps or you will wipe out the ">" already entered.

-bd

Link to comment
Share on other sites

This topic is 7316 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.