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

Question

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

Gianni Ceresa · Answer

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).

Sherry George · Answer

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

John305 · Answer

Thank youuu !