Joining Dates

I have 2 inputs, one is an Audit Date and the other is a list of calendar dates (Day_Month_Year column). Alteryx is seeing the Audit Date coming in as a String format and the Day_Month_Year coming in as a Date format. When I try to convert the Audit Date to a "Date" format, it is only converting to" DateTime". So my join is still not working because the Audit Date field is now "DateTime", but the Calendar Date field is "Date". When I've tried converting both to a "String" I am still not getting any results and it seems I'm just going in circles with these dates.

Date Time

Accepted answers

Qiu

@KmbrlyPC
It seems workingj just fine on my side.

New Workflow1A.yxmd

All comments

Luke_C

Hi @KmbrlyPC

without seeing the workflow it's hard to say exactly what's happening, however you should be able to change the Audit Date to just be a date type and not datetime. See attached workflow where I've done this and the join works.

If you're using the DateTime tool, maybe you chose the 4th option rather than the one lower down?

New Workflow4.yxmd

Qiu

@KmbrlyPC
It seems workingj just fine on my side.

New Workflow1A.yxmd

KmbrlyPC

Thanks, it works now!

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235