Invoice Date formatting

[SH_94]

Hi Community,

Would like to ask how to convert the following the date format to the output as per below.

Original

1.09/29/2015

Output

1.2015-09-29

Do we need to choose the type as date if we need the output as above?

many thanks again for the help

[MarqueeCrew]

Formula:

 datetimeparse([original],"%m/%d%Y")

 this will create a good date for Output. 

cheers,

 mark

[atcodedog05]

Hi @SH_94 

Here is one way of doing it using datetime tool, select string to date and give the input date format.

Workflow:

Hope this helps : )

[Qiu]

@SH_94 
I am not sure if the prefix "1." is important, gave a try.