Conversion of Date issue

[Anjankumar2021]

Hi All 

pls refer to the attached excel and kindly assist.

i see some of them converted into a date format YYYY-MM-DD , but we need all dates should converted to one unique format or no change format. pls help

[Anjankumar2021]

@binu_acs pls assist :)

[aatalai · Accepted solution]

@Anjankumar2021 take a look at the attached workflow, done with a multi field tool 

[Anjankumar2021]

formula should apply on one column that is input because output column is what i got after running workflow.

pls ignore output column

[aatalai]

@Anjankumar2021 take a look at the updated workflow (just unchecked output in the multifield tool (this could also be done with just a formula tool now) 

[Anjankumar2021]

thank you so much for your hep :) 

i got output exactly but i want to change format YYYY-MM-DD to DD-MM-YYYY.  pls advise

[binu_acs]

@Anjankumar2021  use DateTimeFormat() function

DateTimeFormat([Date],'%d-%m-%Y') - change data type to string