Date Calculation Format Error - New to Alteryx

[udles5666]

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.

[JosephSerpis]

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?

[udles5666]

hi @JosephSerpis

Thanks for the tip. Please see attached. (.YXZP file)

Thanks. 

[JosephSerpis · Accepted solution]

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.