Hello everyone,
Given that I have a file name "Test_210908" is there a way for me to get "210908" then convert it to a date 09/08/2021?
Any help will be highly appreciated. Thank you.
Discussion posts and replies are publicly visible
Hi
I quickly created this
a!localVariables( local!fileName: "Test_210908", local!splitDate: index(split(local!fileName, "_"), 2, null()), local!year: left(local!splitDate, "2"), local!month: mid(local!splitDate, 3, 2), local!day: right(local!splitDate, "2"), date(local!year, local!month, local!day) )
Wow! It actually worked. Thanks for this.