I need to calculate date based on other column I’m using
=Date(Year([endDate]),1,1) in a calculated field which needs to return data as DateTime, but it is giving me error:
The formula contains a syntax error or is not supported.
After that I tried to modify the view to take only the year from today date as a string like:
Trim(Text(Year([Today]))) and it is accepting the formula, but no results in the view.
Any suggestions what can be causing the problem? I prefer to make it work like in the 1-st option which I described, but if it is doable in the 2nd, it is also acceptable.