DateTimeParse conversion error

[carterfleming]

Can't figure out how to fix these conversion errors and didn't see any existing posts that helped me out. For reference, I'm trying to create a new column in Alteryx date format based on an existing column and also change the format for the existing column to Alteryx date format. Any and all help is appreciated.

[DataNath · Accepted solution]

Hey @carterfleming, from looking over the document you have provided, your 'Input Date' is in MM-YYYY format (guessing it's months otherwise this is is a very weird date format!). However, in your Formula expression, you're telling Alteryx to parse out the Date and providing MM/DD/YYYY as the pattern, which it can't find as your field is MM-YYYY. Therefore, you'll need to use the following instead:

DateTimeParse([Demo Date],'%m-%Y')

On updating the existing field, as your records are MM-YYYY and therefore 7 characters long, you'll first need to add a select tool and increase the 'Size' of your field to allow for 10 characters when you parse the date and end up with your Alteryx-defaulted date format (YYYY-MM-DD):

Then you should be able to apply the expressions as you wish!

[Andreina · Accepted solution]

Hello!

You have to set in second parameter the format of the incoming date string data, so , in your case should be something like 

DateTimeParse([Invoice Period],"%m-%yyyy")

Hope it helps, 

Regards!

[binuacs]

@carterfleming one way of doing this