Text to Date Calculation? | Community
Skip to main content
Level 4
May 26, 2020
Question

Text to Date Calculation?

  • May 26, 2020
  • 0 replies
  • 330 views

Hi There - Does anyone have a good suggestion on translating text to date w. a calculated field? We currently have an integration that pulls over our development iterations and it laid out as, LTI\Iter\20.19-May08, which = 5/8/20. My only idea is populating my calc w. all Iterations w. an IF statement as shown below, but would prefer not to if there's an easier way?

IF(ADO Iteration = "LTI\Iter\20.19-May08", "5/8/20")

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.