Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Type mismatch error using DateTimeFormat function

csh8428
10 - Fireball

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?

 

screenshot.png

 

Thanks for any help!!

-C

4 REPLIES 4
binuacs
20 - Arcturus

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

csh8428
10 - Fireball

@binuacs  Same error.

binuacs
20 - Arcturus

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

csh8428
10 - Fireball

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

Labels