Skip to main content
Question

How to extract Year from a Date Calculated Field

  • March 1, 2021
  • 0 replies
  • 212 views

I have a Date Calculated Field called OSP Ready Date whose Formula is this: If([Construction Complete?]=true, Max([Coax Construction Task Completed Date],[Fiber Construction Task Completed Date],[Node Install Task Completed Date]),null).

I would like to extract the Year from this calculated date. Can this be done?

When I try: Year([OSP Ready Date]), I get: "expecting date but found number".

When I try: When I try: Year(ToDate([OSP Ready Date])), I get: "expecting datetime/workdate but found date".

------------------------------
Thomas Ringkamp
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
It appears that your field for Year is a date field type. Change it to a formula numeric field type.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------