I am creating a corporate intranet for my employer. I have created a content type, employee, to track employee information such as ID#, name, phone number, address, start date, review date. I have used CCK fields for all of this information.
I have also created a view to list all of the employees with their employee ID#, name, start date, and review date.
The review date comes around once per year, but when inputing the date I am required to input a year. If I have one review date as March 1st, 2008 and another March 2nd, 2007, the second one displays first when sorting. I am only displaying the month and day since the year is irrellavent. I would like for them to be sorted by month and day, excluding year.
I have attempted the following:
* Using a regular text field, but then I lose the date validation of the date field type.
* Have a date field with no year specified (I have researched and it seems this is not possible)
* Sort a view by month and day, but not year. (The views filter allows you to specify month, day or year when filtering, but when sorting you can only select the date as a whole.)
* Calculated field (I cannot figure out the proper code to get it to calculate and put in the current year)
Any suggestions on how to remedy this problem?