Table 6-10. Date and Time Functions
| Basic Syntax | Crystal Syntax |
|---|---|
| CurrentDate, CurrentTime, | CurrentDateTime |
| CurrentDate, CurrentTime, | CurrentDateTime |
| DateSerial(year, month, day), | DateTime(hour, minute, second) |
| DateSerial(year, month, day), | DateTime(hour, minute, second) |
| DateAdd(interval, number, date) | DateAdd(interval, number, date) |
| DateDiff(interval, startdate, enddate, firstdayofweek) | DateDiff(interval, startdate, enddate, firstdayofweek) |
| DatePart(interval, date, firstdayofweek, firstweekofyear) | DatePart(interval, date, firstdayofweek, firstweekofyear) |
| MonthName(date, abbreviate) | MonthName(date, abbreviate) |
| Timer | Timer |
| WeekDay(date, firstdayofweek) | DayOfWeek(date, firstdayofweek) |
| WeekdayName(weekday, abbreviate, firstdayofweek) | WeekdayName(weekday, abbreviate, firstdayofweek) |
