Finding dates using ranges

[bdam]

Ok, so I want to tackle the birthday problem but with a slight twist: find everyone who has a birthday this month including the last 5 days of the previous month. So for December I would find 11/26 to 12/31.

Now, I know how to calculate the day, month and the range but it's the year that trips things up. If you search for a range it always puts a specific year in. So if I search (manually) in the date of birth field for "11/26...12/31" it puts in the current year and shows no results. If I put in "11/26/*...11/26/*" it returns every record in the db.

Thougths?

[bdam]

Got it figured out using multiple requests. One request to find the current month 12/*/* and 5 additional requests for the specific days 11/26/*. This is being done in a script so that works splendidly.

[PaddyO]

Hi,

I was searching to find out how to do a date range, can you show me that calc? I need to use the date range in finding records for a report but I'm not sure what that script should look like...

Thanks!

[mr_vodka]

This thread could help.

Find date range

[PaddyO]

I found a solution here too.

I was just coming back to post this thread when I saw your note. Thank you!

http://fmforums.com/forum/showtopic.php?tid/181154/post/231164/hl/date+range/

[PaddyO]

Spoke too soon. I can't get the script to work. Keeps telling me that there is no valid criteria.

I set up the globals to be Date and Text. Didn't work either way. Is it because the date on my transaction record ( the records I'm trying to find and sort...) is an auto enter and the range is therefore not looking at it.

A better question might be, is the date range formula even looking at the date on my record?

[mr_vodka]

The globals should be date fields. Are you sure that you have set them up as globals? You may want to double check.

The field being an autoentry field should be irrelevant.

[PaddyO]

Disregard.

Embarassed newbie humbly admits mistake.

I forgot to reference my T_DateCreated field in the script...

[The Shadow]

You can also search for a range of days like this:

    11/{26...31}/*

so you could do this in two find requests rather than six.