DIGITS CONVERT TO DATE

[dunkindonut7777]

Hi, How can 6 digits in a field (string) will be converted into date format?

For example:

DATE:

201119

And I want to convert it into

11/19/2020

Can you help me out with this one please?

[MarqueeCrew]

@dunkindonut7777 ,

 I'd try:

datetimeparse([date],"%y%m%d")

 that should work.  You should try references date specified in the help pages for more help.

 Cheers,

mark

[atcodedog05]

Hi @dunkindonut7777 

Here is a workflow for the task.

Output:

Formulas:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[dunkindonut7777]

thanks to this!

[dunkindonut7777]

thanks to this one!!

[atcodedog05 · Accepted solution]

Hi @dunkindonut7777 

If we were able to help you solve your usecase please acknowledge by marking the posts as solution 🙂

Happy to help🙂