Error in Year(Max(DATE))

[#1]

Hi community member,

I am trying get year to date, but I am getting error ,when I am writing the function Year(max(DATE)) .can anyone help me please

regards

rams

[Anonymous]

What do you mean with "getting error"?

If you don't get a value back, it sounds like your DATE value is not formatted as a proper date value. Try converting it to a NUM() to see if it still displays a value, if not, then make sure you format the DATE as a correct date value.