Property "YEAR" function Calculated Formula Output not correct?

Was trying to create a property using the “year” function so as to get the current year only output. No matter what I try it ends up putting the entire date and doesn’t actually give the correct Output.

Hi @GPeters74,

You need to change your output type to “Number”, then it should work.

Best regards!

Okay, will try.

Didn’t realize that this converts a “date” type property and changes it to a “number” type property.

Hi @GPeters74

I am not expert by any stretch buthave you tried chaning the output format to a number?

Date Output will always show as dd-mm-yyyy or any variation thereof depending on your portal preference. So my thinking is even though you just want to output 2025, the expected format is always missing or trying to fill the dd-mm part of that property.

I would try output as unformatted number and see if that works.

Frank