I am using the datediff function and it doesn't seem to be working.
What I am currently using
DATEDIFF(year, creation_date__c, SYSDATETIMEOFFSET()) AS AnniversaryYears
It just gives an empty result in the data extension for AnniversaryYears.
creation_date__c is of the following format: Monday, December 05, 2016 12:00 AM
Any idea what I might be doing wrong?