Expand my Community achievements bar.

Text to Date Calculation?

Avatar

Level 4

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")

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

0 Replies