Skip to Content
0
Former Member
Jul 01, 2015 at 06:26 AM

Default Date values

36 Views

Hello All,

There are two reports pointing to the same universe and Oracle is the backend.

Report 1 has 9 Prompts, Out of which I need to show default values for the Start Date : Current Date whereas End Date: Current Date + 3 months

Report 2 has 7 prompts, Out of which I need to show default values for the Start Date : Yesterday whereas End Date: Yesterday – 7 Days

Currently, Start Date & End date for both the reports are coming from a condition

Begin & End Date :

EVENTSTRT_TS >= to_date(@Prompt('2.Begin Date(mm/dd/yyyy)', 'D' , , mono, free),'dd/mm/yyyy hh24:mi:ss') AND SCHDL_EVENTSTRT_TS < to_date(@Prompt('3.End Date(mm/dd/yyyy)', 'D' , , mono, free),'dd/mm/yyyy hh24:mi:ss')+01

How can we achieve for 2 reports ?

Sandy R