How to extract Year from a Date Calculated Field
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
------------------------------
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
------------------------------
