Trying to create an OTBI Filter to convert string to DATE with current YEAR
Hi, I am trying to create an OTBI analyses that takes a DFF ATTRIBUTE5 in text format with the month and day, and then compares it to the date of the current year . The DFF ATTRIBUTE5 is text format and would have the format "mm-dd" e.g. "11-24"
I found the function to convert a string into a DATE is : DATE 'yyyy-mm-dd'
I then can find the current year, YEAR(CURRENT_DATE) , but I cannot seem to find the correct format .
This is the normal SQL where :
TO_DATE(EXTRACT(YEAR FROM SYSDATE)||'-'||ATTRIBUTE5,'yyyy-mm-dd') = trunc(sysdate)