Difficulty: 🔴🔴⭕⭕⭕

Do dates and date ranges trip you up? This course is intended to reinforce and build your understanding of how to handle dates in your reports. We cover dates and date-times, discrete dates and date ranges. We will review formulas like dateadd() and datediff(), and provide some new toys to play with too. Students will work on two reports, one focused on goods and services, and the other on service restrictions. This 3-hour small group seminar is intended for people who are already familiar with developing reports in Crystal Reports.

Curriculum

• Dates and Datetimes

• Getting the Current Date

• Manual Date Writing

• Date Formatting

• ToText()

• Comparing Dates and Datetimes

• Converting Dates -> Datetimes

• Converting Datetimes -> Dates

• DateAdd()

• DateDiff()

• Discrete Dates and Date Ranges

• Comparing to Previous Periods