Trying to use an expression to show today's date in my template, Pixel Perfect keeps showing it as a number instead of a date. How can I change that?

[artmar]

This same expression works in Qlik instead, showing a date properly.

[Lech_Miszkiewicz · Accepted solution]

text(date(today(),'DD/MM/YYYY'))

Obviously date() by itself returns dual which is number and text and withing pixel perfect it still returns number as expected hence you have to force it to represent text value.

cheers

Lech

[artmar]

Thanks!