Sorting by Date Macro

**InkyDrinky** · 01-02-2017, 06:22 PM

Hello Gurus,

I cannot figure out why this doesn't work for data with 2017 dates in it... it works for 2016 just fine... any help would be AMAZING!

Please Login or Register  to view this content.

**6StringJazzer** · 01-02-2017, 07:50 PM

InkyDrinky, please add CODE tags to your code to comply with our rules.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7.

**InkyDrinky** · 01-03-2017, 11:35 AM

Originally Posted by 6StringJazzer

InkyDrinky, please add CODE tags to your code to comply with our rules.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7.

All Done sir

**Richard Buttrey** · 01-03-2017, 11:56 AM

Hi,

Almost impossible to say unless we can see the actual data. Please upload the workbook.

However your title says this is a Sorting request but it's not entirely clear what your macro is doing. Are you trying to sort a data set using a hierarchy of several columns and is there some reason why the normal standard SORT functionality won't work?

**InkyDrinky** · 01-03-2017, 12:36 PM

I knew I should have attached a file to start! Sorry about that...

Attached is DATA from 2016 that works great... then a file with 2017 that does not work...