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?
Solved! Go to Solution.
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
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 😀👍
thanks to this!
thanks to this one!!
If we were able to help you solve your usecase please acknowledge by marking the posts as solution 🙂
Happy to help🙂