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
Solved! Go to Solution.
@binuacs pls assist :)
formula should apply on one column that is input because output column is what i got after running workflow.
pls ignore output column
@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)
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
@Anjankumar2021 use DateTimeFormat() function
DateTimeFormat([Date],'%d-%m-%Y') - change data type to string