Thanks Dennis for a quick response. Not sure what you mean by helper fields. Do you mean additional fields to hold temporary results? I have already split the date into day, month and year fields. Can I manipulate the day and month fields or do I still need additional helper fields. Hate to ask, but in this case an example would help a lot.
I was hoping to do all this with the formula facility on each report field assignment, but guess that can only be done using the GetExact functions.