DateDiff .Days error within Transformation
Posted: Thu Nov 23, 2023 3:06 pm
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
Removing .Days works to give a timespan but I really need it as an int. Thank you!
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
Removing .Days works to give a timespan but I really need it as an int. Thank you!