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.
Solved! Go to Solution.
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’)
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.
@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.
@Qiu That worked perfectly. Thanx a lot.
You forgot to check change datatype to string. That's why you have the error.
Hope this helps!
Regards,
Tried this too and it worked. Thank you
@messi007 Right I forgot to change the data type to string thats why was getting the error. Thanx