I am trying to calculate when specific events occur during the time of the month. Is there a way of obtaining an “absolute” date value to enable a sort by month date.
For instance if I wanted to sort:
02/02/09
05/02/09
01/04/09
23/04/09
11/05/09
By date (ie earliest in the month) I would want the result to be,
01/04/09
02/02/09
05/02/09
11/05/09
23/04/09
Is this possible, and if so how?
Many Thanks
Bookmarks