لطفا منتظر باشید ...
Appendix D: Crystal Reports Custom Functions
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.
