Skip to Content


Hi Team,

I want to create a date prompt.

Lov's should show Values to range from last completed month to 24 months prior (current month -1 to current month – 25).

Default value: should get the last 90days data, .i.e Default = yesterday– 90 days

Most Important requirement is as follows:

Max amount of data that a user can query for when entering their own dates: 90 days, For this Point Lets take an example:

If user selects Start date : 2015 01 01 and End date: 2015 12 31, then Max amount of data to be fetched is 90 days, i.e from 2015 01 01 to 2015 03 30 (approx.),

Please provide your valuable inputs.

Thanks in Advance



Add a comment
10|10000 characters needed characters exceeded

sivasankar vemula May 26, 2016 at 11:01 AM




1 Answer

Kuldeep Ghosh May 26, 2016 at 11:35 AM

Try something like this in Universe:

Type=@Prompt('1. Enter Schedule Type', 'Default', {'Default', 'Two years'}, mono, free,Persistent,{'Default'})

[Adhoc]= trunc(sysdate)

[Default] (Current date - 3 Months) = add_months(trunc(sysdate),-3)




CASE @Select(..\Type)

WHEN 'Two Years' THEN add_months(@Select(..\Adhoc),-24)

WHEN 'Default' THEN @Select(..\Default)


Add a comment
10|10000 characters needed characters exceeded