Sysdate between start Date and End Date

Question

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 · Answer

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}

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