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?
Solved
Datatype Project / Instance Variable
Best answer by rory.smith
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.
+7If 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
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
