I'm trying to print a report to include records in a range of dates in the "Send Date" field. Ideally I'd like the report to be for the week ending xx/xx/xxxx. Barring that, I'd like to have the user input the beginning and ending dates manually and perform a find based on the user input.

I have set up a screen for the user to enter the date range like this "xx/xx/xxx...xx/xx/xxxx" but would like to find a tighter way of doing this as it is not intuitive and requires the user to be trained in what format to enter the date range in.

Have the user input the week ending date into a global date field, then

Enter Find Mode [ ]

Go to Layout [one with Send Date on it]

Insert Calculated Result [send Date; DateToText(gdate - 6) & "..." & DateToText(gdate)]

Perform Find [ ]

This is, of course, assuming the end of the week is Saturday.

aack! So simple I should have thought of it!!

Just one thing, DateToText is not available in FMPRO7 (as far as I can see), however this worked:

Insert Calculated Result [send Date; gdate - 6 & "..." & gdate]

Thanks so much for the help!

Ack! I meant GetAsText. DateToText is usually required when searching for a range. I wonder if that's changed in FM7?

I just tested Set Field [table::datefield, table::globalDate1 & "..." & table::globalDate2] and it worked! Apparently Insert Calculated Result and GetAsText are no longer required for finding date ranges.