How to CAST Char to Date

Summary

CAST Presentation Variable of Text to Date Prompt in Formula

Content

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)