Find records on date criteria from a script

[Sanjai]

Hi,

Through a script, I want to find all the records in a file where creation_date is >= 01/01/<>. The creation_date field is a date field. I tried to execute a script with the following script steps:

enter find mode[]

set field["creation date, ">=" & texttodate("01/01" & year(status(currentdate)")

If I use the above method then FileMaker interprets the the result as a text data because I am concatenating a string to the date.

I tried using Insert Calculated Result[] but after concatenation with the text field, it shows the total number of days from 01/01/0001 (for eg: it shows '>= 01/01/2005' as '>= >=731947' and FileMaker gives an error to enter data in mm/dd/yyyy format.

Any help would be greatly appreciated.

Thanks in advance,

--Sanjai

[comment]

Try:

">=" & DateToText( Date( 1, 1, Year( Status(CurrentDate))))

[Sanjai]

Thanks. I don't know why I had forgotten to convert the datetotext.

Thanks again,

--Sanjai