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
Discussion posts and replies are publicly visible
a!localVariables( local!date: "2/JAN/2020", local!split: split(local!date,"/"), datevalue( joinarray({ local!split[2], local!split[1], local!split[3] }, "/") ) )
Thank you so much sir,this was my first question ,and got reply very quickly