Jump to content

Searching dates


timboellis
 Share

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

Recommended Posts

  • Newbies

How do I search for dates in this format

I have a database with various dates and I need to search fields that contain a date, however I need to let it search for dates that are 1 year ago.

For example you sign up to my company as a member and the membership lasts 1 year, so i need to find out which ones are about to expire how do i do this.

Thanks

Tim

Link to comment
Share on other sites

Find request with dates do understand basic maths operators. Some examples

<1/1/2006 (before 1st Jan 2006)

>31/12/2000 (after 31st Dec 2000)

1/1/2006..31/1/2006 (between, and including 1st Jan to 31st Jan 2006)

Link to comment
Share on other sites

  • Newbies

I understand this, but in saying this I would need to change this every month, is there not a dynamic way to do this. ie with wildcards

<1/1/2006 (before 1st Jan 200*)

>31/12/2000 (after 31st Dec 200*)

1/1/2006..31/1/200* (between, and including 1st Jan to 31st Jan 2006)

Link to comment
Share on other sites

Yes, there is (in version 8 only). See:

Help > Finding, sorting, and replacing data > Finding records > Finding numbers, dates, times, and timestamps

and

Help > Finding, sorting, and replacing data > Finding records > Finding ranges of information

Of course, you can also script a find using Get (CurrentDate).

Edited by Guest
Link to comment
Share on other sites

You could run a script:

Enter Find Mode

Set field [ Date ; Month(Get(CurrentDate)) & "/" & Year(Get(CurrentDate) - 1)]

Perform Find

In 8, that will do a search on 5/2005 (for the month of may) and that will give you any days in that month.

Hope that helps!

Martha

Link to comment
Share on other sites

How about a calculation field -

Case(get(CurrentDate) <

Date(month(StartDate)+12; day(StartDate); Year(StartDate));

"OK"; "Overdue")

You can modify the '12' to be a variable specified by the user to decide when to start sending renewals.

The end result is the same but it saves messing about with finds on dates.

Edited by Guest
Link to comment
Share on other sites

This topic is 5672 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.