Output Date to Excel in Excel Date Format

[rrafferty2]

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

[mattreynolds · Accepted solution]

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!

[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

[Sharathdhruthi]

Hello

Where you able to fix this issue. If, yes can you please share your solution ?