Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
For something called "common" sense, why is there so little of it around?
 
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!!!!

06
July

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)

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

78 + 73 =