formatDate() in textbox error

[Ted]

Hello,

When using formatDate in a textbox I’m getting the below error:

formatDate(${ReportMonth},‘yyyy-MM-dd’)

It looks like this was an issue twice in 2022 & was archived without a fix.

Text Box with Date Parameter

Hi, Community. I am looking to include a dynamic date parameter in a text box but continually get “Something went wrong”. This blog outlined the initial steps: Dynamic Parameter: [image] Text Box with Parameter: [image] Resulting Error [image]

The newly added Text Visual can't display formatDate(${parameterDate}, 'yyyy-mm-dd'), it always defaulted to bigint timestamp

It might be throwing an error because of the format you are putting in. Months need to be capitalized. Try formatDate(${parameterYesterday},‘yyyy-MM-dd’)

Does anyone know a work around?

[ErikG]

Hi @Ted
i was able to skip the error by changing the parameter value. But as soon as you will do the formula gets overwritten.

As a workaround you could use a insight visual.

BR

[Ted]

That works great - thank you Erik