How to convert number to date format

Hi Everyone,

How to convert “05062018” to 05/06/2018

@chandrika_chandrika, Hi

Please try this out and let me know

Main.xaml (5.8 KB)

1 Like

Hi @chandrika_chandrika,

Is “05062018” a number or String?


Have a look here:

the way to parse it to a datetime and then reformat it is to prefer, as it recognize wrong formats
Ensure following:

However if you want to do it on string base, second demo shows a quick insert


its a string

1 Like

Thank you so much

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.