Requirement: I want to do multiple case when and return the following If trandate is prior to Last year, return “LY” If trandate is current year, return “Current” if trandate is future years, return “LT” Solution: Please try the following: CASE WHEN {trandate} BETWEEN TO_DATE(TO_CHAR(ADD_MONTHS(SYSDATE, -12), ‘YYYY’) || ‘-01-01’, ‘YYYY-MM-DD’) AND TO_DATE(TO_CHAR(ADD_MONTHS(SYSDATE, -12), ‘YYYY’) ||… Continue reading Last Year, Current Formula in Saved Search
Tag: date formula
Date search formula for last month and last year’s last month
Date search formula for last month and last year’s last month
Date formula in workflow
Set the dates in a custom field according to condition.