Skip to main content

Hello,

I defined a Project Variable where I casted the output as date,
When using the variable in a view TX returns an int.
What am I doing wrong?

If you use the 'Show translation' radio button in the 'Edit Custom View' interface and choose to resolve the dynamic variable, you will see it manifests as a string. In the view you need to cast the variable as a DATE (and put ' around the parameter name).


You also need to alias the field name to something different than the variable parameter name as otherwise the value will be put in the field name. 


Reply