Hey,
I have a crosstab query which sets up the Year (yyyy) and Month(mm) and i need it to create the month end date. What i have done is create a regular query and am trying to find an expression i can use to put the dates together and make it month end. I have used the date Part formula before but never had to go in this order, any ideas? cheers,