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.
    In Workday,
    YYYY
     in a date pattern/format means
    week year
    , which is defined to begin at the beginning of the week that contains the year’s first Thursday. Example: The week year 2026 begins in Workday on Sunday, December 28, 2025, since January 1, 2026, is on a Thursday. Dates from December 28, 2025, through December 31, 2025, are in week year 2026, whereas December 27, 2025, is in week year 2025. Week year is intended to be used for week dates (example: 2026-W01-1), though it is often mistakenly used for calendar dates, where the year may be incorrect during the last week of the year. Example: When using YYYY, Workday formats December 29, 2025, as
    2026-12-29
    .
    When you are formatting a date other than a week date, use the year format
    yyyy
    .
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.