Datatime error

[ShreyaSharma]

Hi Team,

Can anyone help me why i am getting this error and how to fix it..

Many Thanks

[DavidP]

A date needs to be in the format yyyy-mm-dd before you can change the data type to Date with a Select tool.

In order to achieve this do the following:

1. Make sure the [Period] field is the right minimum size - use a select tool and set the size to 10 or more

2. Use a formula tool where you select [Period] as the field to change with the following formula:

           DateTimeParse([Period],'%d%b-%y')

This should convert the field to the right format

3. Use a Select field to change the type to Date

[JosephSerpis · Accepted solution]

Hi @ShreyaSharma the only valid format in Alteryx is YYYY-MM-DD so you will need to convert your date either with the DateTime tool or using the formula Datetimeparse. I have mocked up a workflow. 

[BrandonB · Accepted solution]

Because your date is not currently in an actual date format. Try using a DateTime tool to convert it as shown below: