Hi All,
Can anyone help me convert this string into date format so that I can inject into data base
"20171222"
string format is "yyyyMMdd" I need to convert to date format yyyy-MM-dd so that it can be added to database
Discussion posts and replies are publicly visible
a!localVariables( local!textDate: "20171222", date( mid(local!textDate, 1, 4), mid(local!textDate, 5, 2), mid(local!textDate, 7, 2) ) )
Thanks Mathieu , really helpful