This content has been marked as final. Show 2 replies
Set field [Yourtable::yourdatefield; gDatefield1 & "..." & gDatefield2]
Thank you! Your help was perfect, problem solved.
Find records between dates in script
I have written a script to set 2 global date fields: "Start Date" and "End Date" in a Table called Report Dates.
Now I want to find records in other tables where the "Date" field falls in the range of "Start Date"..."End Date"
I cannot come up with an acceptable format for the above bold step. If I try the Find manually it works if I type 1/1/09...1/31/99
I'd appreciate some suggestions.