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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.