So my original file looks like this...
I have tried setting the date as text and adding a 0 padding, then added Transformation rule with the date format MMddyyy but it's still not converting 3142023 to 03-14-2023.
What am I missing here?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156