Search records for range of date
I am trying to search records from x date untill y date. for example i want to search all record created form 13/1/2009 to 14/2/2009.
Can you please tell me how can I do that?
I have created a script but it doesn't work my script is as follow:
Enter Find Mode
Show Custom Dialog ["Find Records"; "enter the date bellow; records::CreatedDate; records::ToDate]
Set Variable [$DateFrom; Value:records::CreatedDate]
Set Variable [$DateTo; Value:records::ToDate]
Set Field [records::searchrang; $DateFrom & "..." & $DateTo
If [Get (LastMessageChoice) = 1]
Perform Find 
records::CreatedDate is a date field
records::ToDate is a date field it is empty field no date on it
records::searchrang is a text field
I will apprecite if any one can help me why it doesn't bring the data or any other easy way