Hi Community,
Very new to Alteryx and need a hand with figuring out the Date Format Error I am getting for new columns I want to add in the attached workflow.
I have a mapping table which has a specific format and cannot change however, I can change the format in Alteryx workflow to determine MTD (Month Till Date) calculations for Actuals, Budget & Forecast.
Can someone please assist in getting the attached working please? I tried google myself but not sure what causing the issue. Thanks.
Solved! Go to Solution.
Hi @udles5666 it looks like you need to change the datetime parse in your formula to "%m.%d.%Y" however you workflow does not have any data so I cannot run it. Can you try to export your workflow as a Alteryx Package via Options - Export Workflow?
Hi @udles5666 your dates in your workflow are coming in as "01.12.2019" when you use datetimeparse you need match the format e.g. %m.%d.%Y". I made some other small tweaks and managed to get your formula to work for one row when I flipped the date format in datetimeparse to %d.%m.%Y. From your sample dataset I couldn't determine which format is correct, so depending on your data flip the day and month in the datetime parse formula. I attached the workflow so you can the changes I made.