Hello,
Please give me a hint. I have this error in my workflow: Date: "08.04.2021" is not a valid Date.
Why? In the excel file and in the metadata this field appears as Date?
Solved! Go to Solution.
Hi @Luk88kk
Alteryx only supports dates in ISO dateformat yyyy-mm-dd. You can convert it to Alteryx datetime using datetime tool. I have attached datetime tool document in the post which should help you to learn the tool and navigate through to solve the usecase.
Here is help documentation on an alternative method using datetime functions.
Hope this helps : )
Thank you I have done as recommended but now I have popped up a problem of this type:
Cannot convert '2014-08-22' to a date/time with format '%B %d, %Y' and language 'English': Invalid month: '2014-08-22' -- expected at least three letters Record #2
Would you please help me to solve this.
Hi @Luk88kk
1. Use Datetimetool to convert input to Alteryx date (String to date)
2. Use Datetimetool to convert Alteryx date to the desired format. (Date to string)
Hope this helps : )
@Luk88kk one way of doing this with the DateTime functions
https://help.alteryx.com/20214/designer/datetime-functions
@Luk88kk I'm a little confused what your starting point is. If you're still stuck, if you share an excerpt of your workflow/data with your objective we can surely help.
@Luk88kk Since the dates are in different format you need to use the datetime function to process the dates as per the given format
It works! You have saved this Monday. Thank you very much. Have a great day and the rest of the week.
You are great!