Script to source/list future events

[skingjack2]

Hi,

 

Likely a stupid question but I'm having issues with it the nonetheless; I'm looking to create a script that

generates a list of upcoming events based on a future date "start_date"; my thoughts are that

this script should generate what I'm looking for however it is providing unexpected results (finding past dates

not future).

 

Go to layout x

Set error capture on

Enter find mode

Set field [jobs_id::start_date; Jobs_ID::start_date &  " >"  & Get ( CurrentDate )]

Perform Find [restore]

Sort records [no dialog]

Go to layout y

View as {view as list]

 

 

Calculated result is a date.

 

I can perform a find manually and get the proper results but not by script.

Any thoughts on what I may be overlooking?

 

Jack

 

[webko]

I think your Set Field is wrong...

 

Seems to try and set it to the value of the field and then > current date?

 

Also, exactly what is then restored from the Perform Find?

 

Try a Ctrl + R after the script has run to see what it's trying to do...

[doughemi]

Try

 

Set field [jobs_id::start_date;  " >"  & Get ( CurrentDate )]