Calculated Column Field Date

Question

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.

Answer 1

In order to create a calculated column as a date you need to use your formula in below format:

=DATE(YEAR,MONTH,DAY)

Using the formula as you have added in question, I am able to create a calculated field which will be in date format. see below:

Note:

1. I have return this field as Date and Time (highlighted in above image).
2. Sometimes comma(,) does not work in formula (I am not sure but it is based on something language on your site). So in that case use semicolon(;) instead of comma(,).

Reference: Date and time formulas.

Answer 2

I tested in my end and the column works just as Ganesh showed. Also i tried with semicolon which pops with syntax error. Besides the possible language reason, try with a new column or new list to see if the issue remains.