Form control for a date

[paulmcdonnell]

Hi Guys,

Hope yoou can help with this really simple one, cos it's driving me mad.

I have a control on a form which shows a date from a table e.g. 07/01/2009

I want the control to show this date, but only for the day and month (the year is irrelevant for the display.)

so i want the control to display 07/01 only.

I've tried =Day([datefield]) & "/" & Month([datefield]) but I'm after 06/01 instead of 6/1

know i'm fussy.

thanks
Paul
#

 

[pbaldy]

Try

=Format([DateField],"dd/mm")

 

[paulmcdonnell]

Thanks Paul
I'm such a thicky.
Paul

 

[pbaldy]

We Paul's have to stick together!