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
Click on the "Start" menu and scroll to "All Programs." Highlight "Microsoft Office" and select "Access" from the menu.
Click "File" then "Open" and select the file that requires a formatted date. Click on the empty space that requires a date.
Enter the text "DateSerial."
Type the date inside a parenthesis in the format "year, month, date" such as "(2010, 11, 5 )" to create the date 05/11/2010.
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)."
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for