Can I use Dashboard Prompt in the individual Column Formula in my analysis?

Summary

Can I use Dashboard Prompt in the individual Column Formula in my analysis?

Content

Hi,

I have a requirement where I need to use the dashboard prompt(Presentation Variable name is EffDate) in the Column Formula of the Analysis and in the column formula I am calculating age as of the EffDate.

I have the query for calculating age(this was used in the stand-alone analysis without any dashboard):

((YEAR(CURRENT_DATE) - YEAR("Worker"."Employee Date Of Birth")) - ((CASE WHEN (CAST(MONTH(CURRENT_DATE) AS INT)*100) + CAST(DAY(CURRENT_DATE) AS INT)   < (CAST(MONTH("Worker"."Employee Date Of Birth") AS INT)*100) + CAST(DAY("Worker"."Employee Date Of Birth") AS INT) THEN 1 ELSE 0 END)) )