Extracting Year from datetime

Question

I know this must be dead simple, but I am utterly new at this.
I have a datetime field "Entry Date", from which I want to create a Year field.&nbsp;
&nbsp;With the Year field as a Formula-Date type, I tried

Year([Entry Date]) = &nbsp;Error: "expecting date but found datetime"
Year(ToDate([Entry Date])) = Error: "expecting date but found number"

I tried a lot of other things, changing the field types in various permutations, but haven't gotten it right.&nbsp; What will do the trick?------------------------------Robin Wendler------------------------------

blakeharrison · Answer

Robin -So close! You've got the right formula - Year(ToDate([Entry Date])) , but the field type is incorrect. The resulting value is a numeric value, not a date. Your formula field needs to be a Formula Numeric instead of a Formula Date.------------------------------Blake Harrisonbharrison@datablender.ioDataBlender - Quick Base Solution ProviderAtlanta GA404.800.1702 / http://datablender.io/------------------------------

robinwendler · Answer

Great-- thank you!------------------------------Robin Wendler------------------------------

Forum Discussion

Extracting Year from datetime

Related Content

Year Formula help

Extract Date and Comment from prepend log entry field

Create a formula duration over 5 years

Help extracting text between unique character

Extracting multiple substrings from a text string