Datatype Project / Instance Variable

  • 24 August 2022
  • 1 reply


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?


Best answer by rory.smith 24 August 2022, 13:58

View original

1 reply

Userlevel 6
Badge +7

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.