Hi Everyone!

I have two global fields of type 'date', that are used to input two dates from the user. I needed a script that will take these two dates and perform a find operation so that I get all the records within these date ranges inputted by the user.

The problem I am running to is that I am not able to put "field1...field2" in the date field in find mode.

Thanks

You have to use Insert Calculated Result, not Set Field.

I am using 'Insert Calculated Result". My calculation is ->

SearchDate1 & "..." & SearchDate2

But it is putting strange numbers like "731774...731778" into the date field.

Did you read the link? You need DateToText(datefield) as well. Dates are internally stored as numbers and must be converted to text in versions lower than 7.

Found the solution (by Audiofreak) after searching some more b4 I would give up, in the forums.

The soution was that the dates had to be first turned into text, using the function dateToText().

so, my calculation will be

dateToText(searchDate1) & "..." & dateToText(SearchDate2)

This worked. Thanks!

The url for that thread is:

http://www.fmforums.com/threads/showflat...=true#Post98713