Sysdate between start Date and End Date

manyam16 · Dec 4, 2017 6:04PM

Hi,

I need to filter the data in OBIEE analytics based on sysdate between startdate and enddate. Startdate and enddate are two date fields.

Can you please let me know how to implement this.

Thank you,

cesar.advincula.o · Dec 4, 2017 6:39PM

Hi, dont understand what is your requirement, if you are more specific i can help you... but you can use a logical SQL..

CURRENT_DATE >= @{START_DATE}

CURRENT_DATE >= @{END_DATE}

Screen Shot 2017-12-04 at 6.48.06 PM.png

Edit: Sorry about the screemshot is in spanish, but the idea is the same

Oracle Analytics Cloud and Server