Creating Prompt in Universe for TODATE+1

[Former Member]

Hi Friends

I have used below Query to create a prompt for TODATE+1 in Universe(Filters) but it is not working. Can anyone help me how to write the prompt condition for TODATE+1 in Universe level.

trunc(@Select(Log\CRSubmitted))<trunc(to_date(trunc(@Prompt('ToDate','D','Log\CRSubmitted',mono,free,not_persistent,))+1))

Thanks In Advance..!

[Former Member]

Hi,

Just to make things a bit more clear.

You are creating a universe filter, where you want the data to always retrieve dates less that the TODATE+1 value.

For eg. If user selects TODATE as 28/08/2013 , you want the date to be returned as 29/08/2013.

If this is what you need.

The formula you have displayed in your topic should workout.

I dont see any issue in the logic you have created, please check changing one bracket.

i.e. you are first truncating the date value returned by prompt, than you are adding 1 and than you are applying todate function.

Can you try first converting it to date using todate than add 1 to it.

Please try below formula, with just adjustment of a bracket.

trunc(@Select(Log\CRSubmitted))<trunc(to_date(trunc(@Prompt('ToDate','D','Log\CRSubmitted',mono,free,not_persistent,)))+1)

Thanks

Gaurav

[Former Member]

Your requirement is not clear.

What date range do you want based on the date that you are prompting for?

For example, do you want all data from the prompted date through to today?

[Henry_Banks]

Hi,

is this a cross post of http://scn.sap.com/message/14308082 ?

regards,

H