Date Merge Calculations

[Lee J]

Can anyone please help.

I would like to create a field which contains the date range to search on.

I ask my users to enter the date range in two different fields.

and then i need to combine these and get FM to search on the calculated result.

I'm looking into the TextToDate() routine but to no joy.

i.e DateStart (Date)= 1/1/01

DateEnd (Date)= 31/1/01

DateResult (Calc)= 1/1/01...31/1/01

Thanks in advance

[Chuck]

The way I handle this is to store the two dates in a two global date fields, then enter find mode (without restoring the find requests) and use

Insert Calculated Result [ Search_Field, gStart_Date & "..." & gEnd_Date ]

Perform Find

Chuck

[Lee J]

Much appreciated, it works a treat the flip side is that they can't accidently modify and date fields to if the layout option changes.

Thanks.

p.s your second name isn't "Weger" by any chance?

Chuck