Hi Team,
Can anyone help me why i am getting this error and how to fix it..
Many Thanks
Solved! Go to Solution.
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
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.
Because your date is not currently in an actual date format. Try using a DateTime tool to convert it as shown below: