Full Version: exclude year from date
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
wsloan311
On a report, I want to just show the month and day (for a birthday list). How do I format to exlude the year?
Thanks.
MattJ
Format([YourDate],"mm/dd")

HTH
Matt
dashiellx2000
Use the Format Function as part of the control source of the control in question.

HTH.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.