Searching dates

[timboellis]

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

[IdealData]

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)

[timboellis]

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)

[comment]

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 May 26, 2006 by Guest

[mz123]

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

[Oldfogey]

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 May 27, 2006 by Guest