Page 1 of 1

DateDiff .Days error within Transformation

Posted: Thu Nov 23, 2023 3:06 pm
by michaelthegreen
Hi everyone

I have a DataTransformation which connects two data sources however when I want to find the number of days between two dates I use the following command
{DateDiff(UserInfo.CertificationDate, Mexico.Date).Days}

but I get this error: extraneous input 'ays' expecting EndOfFile at line 1:57
Screenshot 2023-11-23 150321.png
Screenshot 2023-11-23 150321.png (112.92 KiB) Viewed 2865 times
Removing .Days works to give a timespan but I really need it as an int. Thank you!

Re: DateDiff .Days error within Transformation

Posted: Fri Nov 24, 2023 10:27 pm
by Lech Kulikowski
Hello,

Days property is not supported in dashboards.

Thank you.