Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Become famous for finishing important, difficult tasks
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!


First and Last Days of Time Periods in Crystal Reports

I have just finished a report writing project using SQL Server Reporting Services, where I had to calculate the start and end dates of calendar periods.

It is always during these projects that sometimes I wish I was using the other reporting tool, as they have an easier way of doing things.

So here is a tip to getting Crystal Reports to calculate the first and last days of a calendar time periods:

First Day of the Year:  Minimum (YearToDate)

First Day of the Month: Minimum (MonthToDate)

First Day of Previous Month: Minimum (Last Full Month)

Last Day of Previous Month: Maximum (LastFullMonth)

First Day of Current Week: Minimum(WeekToDate)

First Day of Previous Week: Minimum (LastFullWeek)

Last Day of Previous Week: Maximum (LastFullWeek)


Name *

Email Address *

Comment *

To prove you are human what is:

49 + 36 =