Skip to Content
0
Former Member
May 28, 2013 at 11:12 PM

Last day of last quarter - Crystal 2008

68 Views

Good morning,

I have a crystal report with a record selection that brings back records from 1 January 2012 to the end of the last full quarter. The record selection includes the following:

{table.DateTimeOfIncident} >= date(2012,01,01) and

(if currentdate in Calendar1stQtr then {table.DateTimeOfIncident} < Calendar1stQtr

else if currentdate in Calendar2ndQtr then {table.DateTimeOfIncident} < Calendar2ndQtr

else if currentdate in Calendar3rdQtr then {table.DateTimeOfIncident} < Calendar3rdQtr

else {table.DateTimeOfIncident} < Calendar4thQtr)

This is working correctly.

I also have a formula to put in the header to describe the time period (i.e. This report contains records from 01/01/2012 to xx/xx/xxxx

How do I get the xx/xx/xxxx to represent the last day of the last quarter?

Kind regards,

Anna.