Drop the year from a date in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have a query with a bunch of dates. I just want to drop the year off of
the dates. I didn't find anything in the formatting options, and the =LEFT
function doesn't seem to work so well.
 
You can format the date in a text box on a form or report by setting the
format property to:
mm/dd
Or set the control source to:
=Format([YourDateField], "mm/dd")
You must realize that the actual stored date always contains a year value.
If you really don't want to store a year, consider two fields, one for Month
Number and one for Day Number.
 
Thanks so much! Just what I wanted...a little too easy!!!!

Duane Hookom said:
You can format the date in a text box on a form or report by setting the
format property to:
mm/dd
Or set the control source to:
=Format([YourDateField], "mm/dd")
You must realize that the actual stored date always contains a year value.
If you really don't want to store a year, consider two fields, one for Month
Number and one for Day Number.

--
Duane Hookom
MS Access MVP
--

Dan Connors said:
Hello,
I have a query with a bunch of dates. I just want to drop the year off of
the dates. I didn't find anything in the formatting options, and the =LEFT
function doesn't seem to work so well.
Click to expand...
Click to expand...
 
Back
Top