How to do date searches?
I currently have these columns so I can do various date searches:
- Full Date
- Day of Week
- Day Date
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?