Better Handling for Dates in Excel Lists and Database Ranges

[Malek Badi]

I suggest adding a more intelligent handling for Dates in Excel Lists
For Example when filtering a Date column in a database list users should be
able to filter out for dates that are :
In a Year
In a Month
Between .. and ...
Before Year
After Year
Before Month
After Month
etc...

Instead of the usual filters that are more suitable for numbers and strings..





----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...71655224f6ad&dg=microsoft.public.officeupdate

 

[Bob Buckland ?:-\)]

Hi Malek,

You may want to post this directly to the MS Excel newsgroup using the link below and include the version of Excel you're using when
posting there.

========
I suggest adding a more intelligent handling for Dates in Excel Lists
For Example when filtering a Date column in a database list users should be
able to filter out for dates that are :
In a Year
In a Month
Between .. and ...
Before Year
After Year
Before Month
After Month
etc...

Instead of the usual filters that are more suitable for numbers and strings.. <<
--
Please let us know if this has helped,

Bob Buckland ?
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com