Only show month and day

[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

 

[Rick Brandt]

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

Use a format property of "m/d".

 

[Linda \(RQ\)]

Use a format property of "m/d".

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!