Crystal Reports Online Training

Learn Online, Anytime, Anywhere

Step-by-step tutorials and online videos.

Click Here To Learn More »

9.11 MonthName(), WeekDayName(), WeekDay()

MonthName( ), WeekDayName( ) and WeekDay( )

Just like the DatePart() function, these functions are given a date value and they return part of the date. The difference is that these functions are more specialized than the DatePart() function.

The MonthName() function is passed a number representing the month and it returns the name of the month fully spelled out. There is an optional second parameter that lets you specify whether it should be abbreviated to three letters. Pass True to the second parameter to get the abbreviated name. By default, this is False and it returns the full name.

The WeekDayName() function is passed a number representing the day of the week and it returns the name of the day fully spelled out. Just like MonthName(), you can pass True to the optional second parameter to get the 3 letter abbreviation.

The WeekDay() function is passed a date and it returns a number.

Both the WeekDayName() and WeekDay() functions use a number to represent the day of the week. By default, this is number is a 1 for Sunday and a 7 for Saturday. As discussed for the DatePart() function, you can shift this number by specifying a different first day of the...

Get UNLIMITED Crystal Reports Online Training!

Click Here To Start Your Training!

1500+ Tutorial Pages

Complete Crystal Reports Online Training with over 1,500 pages of better than book quality Crystal Reports tutorials.

Step-by-step Online Videos

Learn at your own pace from the comfort of your home! Pause, rewind and watch online training videos anytime!

Online Community

Members-only community where you can post and answer questions. The community is checked on a regular basis by best selling Crystal Reports book author Brian Bischof to help answer your questions.

Cut & Paste Source Code

Save time with simple cut and paste source code you can use right now in your next report!

Click Here To Start Your Training!