the Manx Man's MS Access Pages

Using the Format Function (005)

The format function is a very useful addition to your Access knowledge. See the help system for more details, but here are some ways that I use it.

format(date(),"mmmm d, yyyy")     gives a string like "January 9, 2000"

format(now(),"mmm d, yyyy h:mm AMPM")      gives a string like "Jan 9, 2000 2:15 PM"

----- *****   this article is incomplete - please check it out again at a later date ***** -----