burbello

Script to filter records by date

Discussion created by burbello on Oct 19, 2012
Latest reply on Oct 22, 2012 by burbello

Hi,

 

I have a Report that as soon as it is called, it performs an script.

However I would like add one more option to filter the records by the current month, once I have a field on the table that stores a date of the record.

 

What I have now is:

...

Enter Find Mode [] -- unchecked Pause option

Set Field - calculated result: TIMETABLE::DATE > 1&"/"&Month ( Get(CurrentDate) )&"/"&Year ( Get(CurrentDate) )

Perform Find []

 

This is not working properly and I cannot see where the problem is.

Could someone help me?

 

In advance I really appreciate the help.

Alex

Outcomes