Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Sysdate between start Date and End Date

Received Response
31
Views
1
Comments
manyam16
manyam16 Rank 4 - Community Specialist
edited Aug 13, 2024 5:53PM in Oracle Analytics Forum

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

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics & AI Lead

    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