Author Topic: Scheduling a report using specific date  (Read 2618 times)

DonQuixote

  • Rock Star
  • *****
  • Posts: 205
  • To Dream the Impossible Dream...
Scheduling a report using specific date
« on: February 20, 2014, 12:49:33 PM »

Scheduler and the dynamic date.

For some reason the scheduler requires dynamic dates but if you only want
to schedule a specific date it may stop you with a message. here is my work around.
In the URM each prompt line is RECORD<30,nn>   where nn is the line number.
in the 'Process after field' run a process that will convert your date to dynamic.
In my example the eighth question used variable WORK<5,6>

~~~~~~~~~~~~~~~~~~~~~~
--- afterField  ---
LOCAL TEMP
TEMP = ICONV(@WORK<5,6>,"D2/")
IF TEMP # "" THEN
  @WORK<5,6> = TEMP - @DATE
END
@RECORD<30,8> = @WORK<5,6>
@VALUE = @WORK<5,6>