Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-02-23
Format Date

Format Date

Security:
Custom Field Management
 domain in the System functional area.
You can configure the calculated field to extract part of a date field and format it as a text field.
  1. Access the
    Create Calculated Field
     task.
  2. Select
    Format Date
     from the
    Function
     prompt.
  3. On the
    Calculation
     tab, select an option from the
    Date Field
     prompt.
  4. As you select an option from the
    Format
     prompt, consider:
    Option Description
    Fiscal Formats
    You can click
    Derived Fiscal Summary Schedule or Fiscal Period from Global Field
     to prompt report runners for returned fiscal periods when running the report.
    Format Mask
    Workday provides additional date formatting flexibility beyond the predefined formats. Example: You can enter
    'The time is:' hh:mm a
     to format the text to
    The time is 09:28 AM
    .
    Mask options are case-sensitive and can combine with spaces, other characters, and single quotes. Hover over
    Format Mask
     to view examples of valid format values.
You can use the calculated field to:
  • Determine the fiscal year and period of an employee's hire date.
  • Extract the month and day from an employee's birth date.
  • Group and summarize headcount activity by month.
  • List workers who have a birthday this month.
  • Produce a list of promotions by quarter.
You can create:
  • Additional calculated fields.
  • New calculated fields from within a format date calculated field.