How to CAST Char to Date
Summary
CAST Presentation Variable of Text to Date Prompt in FormulaContent
Age Band on Line Manager Dashboard is based on CURRENT_DATE rather it should based on Dashboard Date Prompt
Current Formula:
IFNULL(FILTER("Worker Assignment"."Head Count" USING ((TIMESTAMPDIFF(SQL_TSI_YEAR, "Worker"."Employee Date Of Birth", CURRENT_DATE) ) < 26)), 0)
Presentation Variable as Prompt:
Name: AsOfDate
User Input: Text Field
Default Selection: Server Variable(CURRENT_DATE_REP_OTBI)
Tried to modify formula to derive age band based on the above prompt but it is throwing error.
Modified Formula:
IFNULL(FILTER("Worker Assignment"."Head Count" USING ((TIMESTAMPDIFF(SQL_TSI_YEAR, "Worker"."Employee Date Of Birth", @{AsOfDate}) ) < 26)), 0)
0