Expression rule for Date

Question

I want to convert a date from 2/JAN/2020 this format to 01/02/2020 this format. 
 that is if the user adds the date in dd/MM(text)/yyyy , we have to convert it to MM/dd/yyyy 
 
 How can I achieve this

Stefan Helzle · Accepted Answer

You will have to parse such special format manually. Use split() and a list of the month names to convert it.

Sanchit Gupta (Xebia) · Answer

a!localVariables(
 local!date: "2/JAN/2020",
 local!split: split(local!date,"/"),
 datevalue(
 joinarray({ local!split[2], local!split[1], local!split[3] }, "/")
 )
)

tushark8069 · Answer

You can try this approach

Expression rule for Date

Top Replies