An Expression Filter of a date ( between sysdate and sysdate +6 months) — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

An Expression Filter of a date ( between sysdate and sysdate +6 months)

Received Response
444
Views
4
Comments
John305
John305 Rank 5 - Community Champion
edited Aug 13, 2024 6:03PM in Oracle Analytics Cloud and Server

Hi everyone,

I am new in OBIEE , i want to create an expression filter of a date that should be between Current date and Current date + 6 months

My question is : What is the fonction for Current date + 6 months !

Thank youuu

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Use this TIMESTAMPADD(SQL_TSI_MONTH, 6, CURRENT_DATE) for current date plus 6 months and TIMESTAMPADD(SQL_TSI_DAY, 0, CURRENT_DATE) for current day.

  • John305
    John305 Rank 5 - Community Champion

    Thank youuu !

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    You are welcome. Also take a look at the TIMESTAMPADD function in OBIEE to see the other available  options

    pastedImage_0.png

  • Gianni Ceresa
    Gianni Ceresa Mod

    Just a detail: instead of  TIMESTAMPADD(SQL_TSI_DAY, 0, CURRENT_DATE) use directly CURRENT_DATE .

    It returns the exact same value but simpler to parse and totally avoid any date calculation by mistake (keep it simple).