Home Code Format a date in Microsoft Access database

Format a date in Microsoft Access database

997
0

Data Manipulation 101 – Formatting a date field for output. More information than you’ll ever need on this site: http://www.techonthenet.com/access/functions/date/format.php

Example

Convert a date field from mm/dd/yyyy to remove the slashes:
Format([date], “mmddyyyy”) will get you 01201975 If the date was “1/20/1975”

LEAVE A REPLY

Please enter your comment!
Please enter your name here