on 2016 May 26 12:01 PM
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
Regards,
Siva
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)
[Filter]=
@Select(Date)
BETWEEN
CASE @Select(..\Type)
WHEN 'Two Years' THEN add_months(@Select(..\Adhoc),-24)
WHEN 'Default' THEN @Select(..\Default)
END
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.