Type mismatch error using DateTimeFormat function

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

Help

Preparation

Expression

Accepted answers

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

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

@binu_acs Same error.

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

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

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