Databases with Microsoft Access 3 –Tables: Date Time Field Types & Custom Date Formats

About this tutorial:

Video duration: 00:14:50
Date / Time data types in Access

Size: 8 Bytes.

Date format building blocks, that can be assembled in any desired combination.

d: shows the day: ie. 8, 12
dd: shows day with leading zero: ie. 08, 12
ddd: shows weekday in short form: ie. Mo, Tu
dddd: shows weekday in full: ie. Monday, Tuesday

m: shows the month: ie. 3, 11
mm: shows month with leading zero: ie. 03, 11
mmm. shows month name in short form: ie. Mar, Nov
mmmm: shows month name in full: ie. March, November

yy: shows year without century: ie.: 98, 15
yyyy: shows year with century: ie.: 1998, 2015

These building blocks can…

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads