Prompt to display dates

66 Views

Hi ,

I would like a prompt which display dates to have default values.

The End Date is the current date and Begin Date is the fifth day from current date.

I created 2 objects (CURDAY and PRIOR 5 DAY) which represents these variables in Designer and use them in the extended prompt syntax.

The syntax applied is:

@Select(Calendar \Data Rif) BETWEEN @Prompt('Enter Begin Date','DATE','Calendar \Date Rif,MONO,FREE,NON-PERSISTENT, ,) AND @Prompt('Enter End Date', 'DATE', 'Calendar \Date Rif,MONO,FREE,NON-PERSISTENT, {PRIOR 5 DAY},)

CURDAY is an object in designer which returns the date of the current day whereas PRIOR 5 DAY returns the date of the fifth day from current date.

Unfortunately, it doesn't function. The prompt still ask for dates.

Where I am wrong or is there any other workaround I can use

Thanks in advance

krish