Solved
Parse a string from a file name and convert to date.
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.
gayathris111098Answer
Inspiring
September 8, 2021
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)
)