How to do MAX Date Logic less than Prompted AsOfDate in Analysis
Summary
Trying to get the maximum Salary Change Date in OTBI AnalysisContent
I am trying to convert a filter to SQL to get the maximum Salary Change Date that is less than or equal to a prompted AsOfDate in an OTBI Analysis. Here is the filter I am using:
"Compensation - Salary History Details Real Time"."Salary Details"."Salary change date" =
SELECT MAX("Compensation - Salary History Details Real Time"."Salary Details"."Salary change date")
FROM "Compensation - Salary History Details Real Time"
WHERE "Compensation - Salary History Details Real Time"."Salary Details"."Salary change date" <= '@{AsOfDate}{@{system.currentTime}[YYYY-MM-DD]}'
Tagged:
1