Printing a date without the year

Printing a date without the year

Post by QyBTY2hyb2 » Fri, 02 Apr 2010 01:40:01


I am new to Access, and I want to know how to display just the month and the
day not the year. Is there anyway to do this
 
 
 

Printing a date without the year

Post by RGFuaWVsIF » Fri, 02 Apr 2010 01:46:02

Display it where? Form, Query, Report???

One option would be to use the Format(), somthing like
Format(Date(),"mmmm-dd")

Lookup the Format function to see all the variables available to control the
output format.
--
Hope this helps,

Daniel Pineault
http://www.yqcomputer.com/
For Access Tips and Examples: http://www.yqcomputer.com/
Please rate this post using the vote buttons if it was helpful.