AnsweredAssumed Answered

How to do date searches?

Question asked by brett_ on Mar 10, 2011
Latest reply on Mar 16, 2011 by Sorbsbuster

Title

How to do date searches?

Post

I currently have these columns so I can do various date searches:

- Full Date
- Day of Week
- Day Date
- Month
- Year 

My searches are similar to:

- Find all second Mondays in March
- Find all June 5 (for every year)
- Find all June 5 (for every year) plus some other none date attribute

Do I really need additional attributes such as those above to do these searches? I'm breaking date apart to allow searchable attributes.  It would be nice to only have full date (less data entry) and still be able to search of various attributes of date.  Is that possible? 

Outcomes