How to find the last day of a quarter?

[samaba]

Hello Everyone,

What I need to find is the Quarter Ending Date.

The situation is:
The report is based on a [qryCalculations], with parameters from a custom dialog box:
What Quarter? [txtQuarter]
What Year? [txtYear]

The query filters down the records if they were either opened or closed during the specified quarter.

I also use the above information for the Sum(iif(datepart() )) statements to count the cases opened [opendate] or closed [closeddate]during that quarter.


I have gone round and round trying to figure out how I can get this information from what I already asked the user. . .

Thanks in Advance!

 

[samaba]

Feel Really Dumb now!!

I just ask for the Quarter Ending Date and use the datepart() to get the other two pieces I need. . .