Help performing a find

[faada]

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.

[-Queue-]

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.

[faada]

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!

[-Queue-]

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

[-Queue-]

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.