Output Date to Excel in Excel Date Format

Hi All:

How do I output a date in Excel Date format from String format.

I used an Alteryx formula to change from yyyymmdd to mm/dd/yyyy which is displays and outputs as a string. I need to convert to a filter for real dates as shown in column D.

I tried data cleansing tool and changing to date type in select tool, but did not work, shows as null. I am sure solution is changing the data type somewhere in workflow, I think.

I attached output sample.

Thanks

Book1.xlsx

Accepted answers

mattreynolds

Alteryx is pretty particular about the ISO format of strings to be converted to dates.

This formula did the trick: todate(left([Original Date],4)+"-"+substring([Original Date],4,2)+"-"+Substring([Original Date],6,2))

Example workflow is attached. If this helps, please mark as solution. If not, happy to revise!

Excel Date Example.yxmd

All comments

mattreynolds

Alteryx is pretty particular about the ISO format of strings to be converted to dates.

This formula did the trick: todate(left([Original Date],4)+"-"+substring([Original Date],4,2)+"-"+Substring([Original Date],6,2))

Example workflow is attached. If this helps, please mark as solution. If not, happy to revise!

Excel Date Example.yxmd

grazitti_sapna

Hi @rrafferty2 ,

Please refer to the screenshot as it will be the easiest way to get the desired output by using date time tool.

rrafferty2

Thanks, a good alternative solution

Robb

tonysavio

Hi @grazitti_sapna,

I am facing something slightly different.

I have a field which has date datatype in Alteryx workflow. And it is coming to Excel through Render tool as number. The end user is telling me that he needs the date in dd-MM-YYYY format. Even when I convert the string format, its coming to excel as number and hence he is not able to filter based on year or month.

But when I enter the date manually, it quickly changes to date type and I am able to filter based on year for that date.

Please help if you know how to sort this out.

Is there any way we can get the dates coming from Alteryx to be filtered based on year and month as in the example on this original question?

Thanks,

Tony

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335