How to Convert this excel Date into Text

[Kinetic_analytics]

Hello:

How to Convert this excel Date into alteryx " =IF(A1>0,TEXT(A2, "YYYY") & "-" & TEXT(A2, "MM"),0)

Thanks

[christine_assaad]

Hi @Kinetic_analytics 

You can convert the dates into format that Alteryx recognizes (YYYY-MM-DD) using the Datetime tool.

Then you can use the datetimeformat function to get it in the desired format YYYY-MM

Hope that helps. Cheers!

[Qiu · Accepted solution]

@Kinetic_analytics 
I think we can use a multi row too.

[Kinetic_analytics]

Thank you.