Date Calculation Format Error - New to Alteryx

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.

TEST - Date Format.yxmd

Test - Alteryx Date Format.JPG

Expression

Accepted answers

JosephSerpis

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.

TEST - Date Format.yxzp

All comments

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.

TEST - Date Format.yxzp

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335