String to date

damen
damen Contributor
edited February 2023 in Beast Mode

Hi,

I'm trying to take the 'DUE DATE' column below (covered by the mouse) and turn those numbers into dates. 20123 is supposed to be 02/01/23

The solution I first thought of was to just split the columns but because it is showing up as text, it wont do that.

Is there a beast mode to just pull the last two, the middle two and the remaining digits into their own separate columns?

I am working in magic etl and am hoping to continue to do so

If this helps, feel free to agree, accept or awesome it!

Tagged:

Best Answer

  • damen
    damen Contributor
    Answer ✓

    @MichelleH Beautiful. That worked out!

    If this helps, feel free to agree, accept or awesome it!

Answers