Oracle Analytics Cloud and Server

Sysdate between start Date and End Date

Received Response
21
Views
1
Comments

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,

Answers

  • 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