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:
Moderate

Other People Are Reading

Instructions

  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

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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