Change date format of Multiple Fields from YYYY-MM-DD to DD-MM-YY

[DataPirate26]

Can somebody assist me to create a single Formula that will change Multiple Fields date format from "YYYY-MM-DD" to DD-MM-YY. I don't want to use datetime tool as I have 7 date fields which needs to be converted to this same format. 

[DataNath]

If you use a multi-field formula, you can just tick the fields you want to apply this change to and use the following:

datetimeformat([_currentfield_], ‘%d-%m-%Y’)

[DataPirate26]

I am getting this below error. All the fields are in date format already. Just need to change it to DD-MM-YY

[DataNath · Accepted solution]

The incoming fields need to be in string format so if they aren’t, you can wrap them in tostring():

DateTimeFormat(ToString([_CurrentField_]), ‘%d-%m-%Y’)

If not, maybe just add a select tool before the Multi-Field and make the target fields string data types first.

[Qiu · Accepted solution]

@DataPirate26 
We can do it either by a Transpose and CrossTab or with a Multi-Field Formula for this kind of situation.

Below is a quick sample.

[DataPirate26]

@Qiu That worked perfectly. Thanx a lot. 

[messi007 · Accepted solution]

@DataPirate26 ,

You forgot to check change datatype to string. That's why you have the error.

Hope this helps!

Regards,

[DataPirate26]

Tried this too and it worked. Thank you 

[DataPirate26]

@messi007 Right I forgot to change the data type to string thats why was getting the error. Thanx