Appendix D: Crystal Reports Custom Functions

book list add book to my bookshelf create a bookmark purchase this book online

mastering crystal reports 9
Appendix D - Crystal Reports Custom Functions
Mastering Crystal Reports 9
by Cate McCoy and Gord Maric
Sybex 2003

Custom Date Functions

The Date functions provided in the Crystal Repository allow you to do date arithmetic for specific tasks. You can calculate the weekends and holidays in a workweek, figure out when the Easter holiday is, or determine the first and last days of the month or the quarter.

cdDateAddSkipWeekends Given a number of workdays and a start date, returns a due date that doesn’t include weekend days.

cdDateDiffSkipHolidays Given a number of workdays and a start date, returns a due date that doesn’t include weekends or statutory holidays.

cdDateDiffSkipWeekends Given a start date and end date, returns the number of workdays between them, excluding weekends.

cdDateSkipAddSkipHolidays Given a number of workdays and a start date, returns a due date that accounts for weekends and statutory holidays.

cdEasterDate Given a four-digit year, calculates the date Easter falls on in that year.

cdFirstDayOfMonth Given the current date, returns the first day of the month.

cdFirstDayOfQuarter Given the current date, returns the first day of the quarter.

cdLastDayOfMonth Given the current date, returns the last day of the month.

cdLastDayOfQuarter Given the current date, returns the last day of the quarter.

CdSpecialDateRange Given a date and a text parameter, returns a data range that meets the criteria; the text parameters are accounting phrases like "Aged0to30Days" and "Aged31to60Days."

cdStatutoryHolidays Returns an array of 10 standard holidays in the United States and Canada.

Use of content on this site is expressly subject to the restrictions set forth in the Membership Agreement
 
Conello © 2000-2003     Feedback


Mastering Crystal Reports 9
Mastering Crystal Reports 9
ISBN: 0782141730
EAN: 2147483647
Year: 2005
Pages: 217

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net