Date from a formula comes out very ugly - how do I fix this?

[BL1]

Hey all - I'm running a formula column with a lot of IFs in there. Only 1 out of the 6 possible responses returns a text field, the rest are date fields.

The dates come out in a very ugly way, this is how it looks: 
2023-07-12T23:06:37.000Z

It basically makes it impossible for me to use / property view.

After some playing around with it, I've understood that the issue here is with the fact that one of the values returned is a text field.

However, the way I have the formula and the intended use. Unfortunately, I can't do anything else but have a text in one of the IF's (since it's the if true, not false, that I could just leave empty).

I've tried using the time parse formula like this: DATETIME_PARSE(the if formula), but the result is an error.

How do I make this work?

[pressGO_design · Accepted solution]

Try making a new formula field that takes the output of the IF statement and see if the formula below works

DATETIME_PARSE(DATETIME_FORMAT({Date}, ‘MM/DD/YYYY’))

[BL1]

Thank you! That works. Is this the only solution, or is there any way to do this without making a new column?

[pressGO_design]

You should be able to put the whole IF formula where the {Date} is and have it work. Theoretically, anyway.