Only show month and day

  • Thread starter Thread starter Linda \(RQ\)
  • Start date Start date
L

Linda \(RQ\)

Hi,

Access 2003. On my report, I am running out of room. I don't need the
year at the end of my date. I want it to display as 2/2 instead of
2/2/2007. I have conditional formatting on this. It is shaded when the
date is today's date. I have short date selected in the format properties.
Can I override this?

Thanks,
Linda
 
Linda said:
Hi,

Access 2003. On my report, I am running out of room. I don't need
the year at the end of my date. I want it to display as 2/2 instead
of 2/2/2007. I have conditional formatting on this. It is shaded
when the date is today's date. I have short date selected in the
format properties. Can I override this?

Thanks,
Linda
Click to expand...

Use a format property of "m/d".
 
Rick Brandt said:
Use a format property of "m/d".
Click to expand...

Sheesh! No Parentheses, commas or quotes? I've been trying all kinds of
wacky things.

= Format(Date(), "dddd, mmm d yyyy")
This is what access change it to"= For"m"at("d"ate(), m, d)"

This is simply what worked...
m/d
Thanks!
 
Back
Top