Answered

Format Date String

(0) Share

Report

Posted on by apann

Hello!

I seem to have some trouble trying to convert this string (12202019) into a correctly formatted date. We are receiving dates without any "/, -" just numbers.

I want to turn 12202019 --> 12/20/2019. I tried to use formatDateTime and couldn't figure out the correct way to do this.

Any suggestions?

Thanks.

I have the same question (0)

All responses (3)

Answers (2)

RobElliott 10,278 Super User 2025 Season 2 on at

Like (0)

Report

Re: Format Date String

@apann have you tried using the Convert time zone control?

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
Verified answer

ScottShearer 25,240 Most Valuable Professional on at

Like (1)

Report

Re: Format Date String

@apann

I don't believe that any of the date/time expressions or actions will work for you as they assume that you are starting with a valid date/time string. I suspect that you'll need to use the substring() expression three times to break your string down into three parts. Then use the concat() expression to put the parts back together with a "/" or "-" in between. It's ugly but I don't see any other way.

Was this reply helpful? Yes No
Verified answer

apann on at

Like (0)

Report

Re: Format Date String

@RobElliott Yes, I've tried that as well, but this only works if the date is already in a date-time format for ex: 11/22/3333.
But I found a workaround for this issue. I ended up breaking the string apart using the take() and skip() functions and concatenating the strings all together with a / in between. Which is somewhat close to @ScottShearer's idea.
So this works out, thanks guys.

Was this reply helpful? Yes No