Finding a date

[DanBrill]

Hi,

I have a page where users enter search criteria as global fields. When they execute the search I'm using a script to enter the Find mode, and then using the SetField script step to set the values of the fields to the values they entered in the global fields. This works fine except for date fields. I want the user to be able to set the field as a single date or as a date range, such as 1/1/1970 ... 1/1/1980.

If I set the global as a date field, it won't let me enter date ranges. If I set it as a text field I can, but then it doesn't find the date properly. I'm using the TextToDate function with the SetField step.

Any thoughts?

Thanks,

Dan

[kenneth2k1]

When using date fields in calcs, you'll want to use Insert Calculated Result [ ] instead of Set Field [ ]. Make sure that you switch to a layout that has the date field on it in order for it to work.

This is just a quick reply. If you still have problems, I can get the exact calc if you give the names of your fields.

Ken

[DanBrill]

Thanks, that does it. Bit of a hassle having to be on a layout with that field, but easy enough to fix.

Thanks again,

Dan