How to Use the Date Serial Function to Format a Date

Written by breann kanobi
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Use the Date Serial Function to Format a Date
Format the date using the Access Date Serial function. (Jupiterimages/Brand X Pictures/Getty Images)

The database software Access, part of the Microsoft Office Suite, uses a function called "Date Serial" to format dates. In order to appropriately format a date, you must enter a date in the appropriate field. Instead of any one number, you can enter a calculation, such as "10-1" and return the appropriate number, such as "9." Access dates are always formatted in the form Month/Day/Year with a four-digit year.

Skill level:

Other People Are Reading


  1. 1

    Click on the "Start" menu and scroll to "All Programs." Highlight "Microsoft Office" and select "Access" from the menu.

  2. 2

    Click "File" then "Open" and select the file that requires a formatted date. Click on the empty space that requires a date.

  3. 3

    Enter the text "DateSerial."

  4. 4

    Type the date inside a parenthesis in the format "year, month, date" such as "(2010, 11, 5 )" to create the date 05/11/2010.

  5. 5

    Manipulate portions of the date, if desired. Click on the text box that contains the date then select "ControlSource." To manipulate the month of a date, enter "DateSerial" then the date in the form "(year(date()), " then "month(date(),1)."

  6. 6

    Add a new year by writing "NewYear =" then "DateSerial()." Enter the appropriate year in the parenthesis followed by a one and a comma twice, such as (2010, 1, 1)." Change year withing "NewYear" to "Month" or "Day" to add a new month or date.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.