Create month end date, from Month(Numberic) and Year(Numeric)

[mike02]

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,

[recyan]

If I have understood your requirement correctly, one way could perhaps be :
Data Available : Month ; Year.
Get the 1st Date of the Month & Year under consideration.
Get the 1st Date of the next Month.
Subtract a day to get the last Date of the Month & Year under consideration.

Thanks

[RuralGuy]

I think this link should help: http://support.microsoft.com/default...b;en-us;210604

[mike02]

I used the Date serial function:

Dateserial([Years],[Months],1)-1

Worked like a charm!

[RuralGuy]

This should work as well: DateSerial([Years],[Months]+1,0)