AnsweredAssumed Answered

Search records for range of date

Question asked by lamp on Apr 30, 2009
Latest reply on May 7, 2010 by mrvodka

Title

Search records for range of date

Post

Dear All,

 

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 []

End If

 

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

 

Thanks

Lamp

Outcomes