Date Prompt Automatically filled with system date

scheduling XI Scheduler
1

Hello Colleagues,

I have a webi report with date prompt.
I want to schedule this report for my user, but I want that date prompt will automatically takes the system date and run the report based on the same prompt.
Is there anyway to that in infoview??

Waiting for your reply… :mrgreen:

With Regards,
Sandeep

sandeep_sinha (BOB member since 2008-08-27)

2

Very brief:

You have to use a magic date such as 01/01/1900 (instead of sysdate/Oracle), then code your predefined condition in your universe accordingly (set the default value inside your @PROMPT extended syntax to “01/01/1900”), for example:

Table.SomeDate = @PROMPT ('Enter a date or choose 01/01/1900 fo today's date', 'D', ...)
OR
(   @PROMPT ('Enter a date or choose 01/01/1900 fo today's date', 'D', ...) = '01/01/1900'
   AND Table.SomeDate = TRUNC (sysdate)
)

Note:
This is Oracle syntax (sysdate) and you might have to do some data type conversion as ‘01/01/1900’ is of data type STRING and not DATE

Andreas :de: (BOB member since 2002-06-20)