Date Filtering in Excel after Alteryx report is generated

[verde0903]

Hello,

I am attaching an example of a situation am having where in Excel I cannot filter by dates once the Alteryx report is generated.  Please review and let me know if I am missing a formula or setup.

Regards,

Maylen

[rzdodson]

Drop a Select tool before your Output tool that generates your Excel file. In that Select tool, change the data type of your date field from DateTime to Date. An alternative is to use a Formula tool to convert your date/time field to a date using the DateTimeFormat function like such:

DateTimeFormat([yourdatefield],"%Y-%m-%d")

Hope that helps

[verde0903]

Hi rzdodson,

Never worked.  My date format is a V_WString.

Thanks,

Maylen

[rzdodson]

@verde0903 I offered two approaches. Which one are you referencing?

As an aside, when able, would you be able to share the original workflow so I can troubleshoot what may be going on?

[verde0903]

Sorry I meant to type, neither worked.  I tried both suggestions made.

Regards,

Maylen

[verde0903]

@rzdodson any other suggestion(s) you may have that I can try?  Thanks

[rzdodson]

@verde0903 attaching a couple of other options for you. I think the first one is the cleanest to use if I understand the issue you are facing. Let me know if either works for your use case.

[verde0903]

Thanks I will try them.