Answered

Error Year Formula

(0) Share

Report

Posted on by Rirag

Hello All,

I'm trying to use the Year formula in a calculated column in my table with the objective of extracting only the year from a Date column. However, I have this error: "Year cannot be performed on this input without a time zone conversion, which is not supported in formula columns."

Any advise on How I can solve this issue ?

Thank you !

Categories:

Microsoft Dataverse

Tables

All responses (2)

Answers (1)

Verified answer

AhmedSalih 6,678 Super User 2025 Season 1 on at

Like (2)

Report

Re: Error Year Formula

Hello, @Rirag , it will work if your DueDate Column setting is set to Date Only or Time zone independant:

If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.

Visit my Blog: www.powerplatformplace.com

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos
armanaxf 32 on at

Like (0)

Report

Re: Error Year Formula

I had run into this issue recently where I wanted to take a date column and get the year using the PowerFx column and found it didn't seem possible.

Possible workarounds could be to use a Power Automate flow to update the row when a record is created, or use a low code plugin. I'm sure other options exist as well. We went down the Power Automate route.