Type mismatch error using DateTimeFormat function

[csh8428]

I am using the following function in a Mult_Field Formula tool: DateTimeFormat([_CurrentField_],"%d/%m/%Y")

I'm getting the following error: "Type mismatch. Number provided where a string is required."

This error appears immediately after entering in the function, even before I've picked a field.

It occurs after I pick a field(which is a date type).

It occurs after picking multiple fields(which are date types).

Any ideas/fixes on this?

Thanks for any help!!

-C

[binu_acs]

@csh8428 select the change output type to string and try again?

[csh8428]

@binu_acs  Same error.

[binu_acs]

@csh8428 I just noticed that, if you add toString([_CurrentField_]) function the error will not show

[csh8428 · Accepted solution]

Had to use 2 multi-field tools.

1: Convert the date fields to string fields

2: Convert format of string fields from step 1 to dd/mm/yyyy

[GavriloPrincip]

can you share screenshots or the formulas you used to solve?

[csh8428]

@GavriloPrincip This was so long ago I don't remember which workflow I needed this for or the data-set I was trying to change.