Printing a date without the year

C

C Schroder

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
 
D

Daniel Pineault

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.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vba to change displayed year automatically. 14
Hello happy new year to all, Text box input for year of purchase 0
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Error on Query with DateSerial() 0
Access 2 Digit year in Access Text Box 3
Add one year in second combobox in vba 0
How do I get ACCESS to calculate years, months, days for a birth d 2
Date field format 3

Top