What do I have to do to get the “GetDateYear” function to actually work AND to just give me the year. I’m trying to just pull out the year from a field labeled “date”. It gives me the answer 1/1/1970 every time, no matter what date is in the “Date” field. Also, shouldn’t this equation give me only the year? I have my “equation type” as “date”. I have my “result type” as “date”. What am I missing?
Hi @Suzanne,
The Equation Type needs to be set to “Numeric” in your equation field for this function to return only the year (since it’s just a number). Have you tried that already?
I could have sworn that I did try that and it didn’t work, but just tried it again and it did the trick! Thank you so much!
1 Like