Extracting Year from datetime
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.
With the Year field as a Formula-Date type, I tried ...
Forum Discussion
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 Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
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 Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Great-- thank you!
------------------------------
Robin Wendler
------------------------------
------------------------------
Robin Wendler
------------------------------
