Obtain Month and Day in Code

[mattc66 via AccessMonster.com]

Hi All,

How would I obtain the current Month and Day in Code.

I want it to be formatted as MMDD.

Thanks
Matt

 

[Brendan Reynolds]

? Format(Date(),"mmdd")
1109

 

[mattc66 via AccessMonster.com]

When I add that to my code it returns "12:00:00 AM". Are you sure this is
what you type in VB?

? Format(Date(),"mmdd")
1109

Hi All,

[quoted text clipped - 4 lines]

Thanks
Matt

 

[Douglas J. Steele]

What Brendan's suggested is definitely correct. Exactly where what did you
type, and where did you type it?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

When I add that to my code it returns "12:00:00 AM". Are you sure this is
what you type in VB?

? Format(Date(),"mmdd")
1109

Hi All,

[quoted text clipped - 4 lines]

Thanks
Matt

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.com