Script for search within a date range

[M.A]

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

[-Queue-]

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

[M.A]

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

SearchDate1 & "..." & SearchDate2

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

[-Queue-]

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.

[M.A]

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