Basics of Datetime Fields Learning Series (Basic-Intermediate) (ACL 210)

2 - Basic-Intermediate


Self-paced online course
3-5 hours

Recommended Skills/Experience prior to taking course:
• Intermediate
• Ability to create unconditional and conditional computed fields

Datetime fields may be presented in a variety of formats, including ones that include entire time stamps (such as YYYY-MM-DD hh:mm:ss). While this allows for much more granular and powerful analysis, sometimes, you may only want to work with a certain component of the field, such as the month. For example, calculating how many transactions occurred in a given month.

Episode 1 Part I Objectives:
• Create unconditional computed fields to:
• Parse various year, month, and day components from a datetime field
• Convert each of these numeric computed fields to character fields
• Calculate the day of week (ex. Saturday) and the month name (ex. June)
Functions used: STRING(), CMOY(), CDOW(), DAY(), MONTH(), and YEAR() functions.

Episode 1 Part II Objectives:
• Create conditional computed fields to:
• Calculate the fiscal year
• Calculate the fiscal quarter
Functions used: BETWEEN(), YEAR(), and STRING() functions.

Episode 2 Objectives:
• Determine the number of and subtotaled amount of transactions in each fiscal year and month (Classify command)
• Determine the number of and subtotaled amount of transactions in each fiscal year, quarter, and month (Summarize command)
• Generate a detailed summary of transactions by month and day, and transactions by User ID and day of week (Cross-Tabulate)

Estimated Time: 3-5 hours Level: Intermediate CPE: None - 0

  • Introduction + activity files
  • Navigating this course
  • Using Launchpad
  • 1 | Creating computed fields
  • 1 | Creating unconditional computed fields
  • 2 | Creating conditional computed fields
  • Quiz 1 - Creating computed fields
  • 2 | Analyzing computed fields
  • Analyzing datetime fields
  • Quiz 2 - Analyzing computed fields
  • 3 | Using scripts to reuse computed fields
  • Using scripts to reuse computed fields
  • Quiz 3 - Reusing computed fields
  • additional
  • What's next?
  • Additional Resources
  • Feedback Survey
Completion rules
  • All units must be completed
  • Leads to a certification with a duration: Forever