Refer to ONLY THE MONTH??

[taimysho0]

june, quick question, for the post where you put:



MonYearReq: Month([Date Column]) & Year([Date Column])

this will spit out for example: 012012

how do i modify this to display the day also? and in this format for example 01/18/2012


thanks so much june, you're the best

[June7]

MonYearReq: Month([Date Column]) & Year([Date Column]) will take 01/23/2012 and spit out 12012.

Why do you need to day part? If you already have a full date, why break it up and put back together?

Format(Date()),"mmddyyyy") will take 01/23/2012 and spit out 01232012.

Day(Date()) will take 01/23/2012 and spit out 23.

Here is a resource to learn what functions are available for Access and VBA http://www.techonthenet.com/access/functions/

[taimysho0]

i see, the reason why i asked was because i wanted to format my [date column] to date only, since it contained the date AND the time.

[June7]

A date/time datatype field always has a data and time components. You might not see it but it is there. If you don't provide a part Access will make assumption. For time I think is 12:00:00 AM and date something like 1/1/1900. The Format property doesn't alter that. Format function will present altered value as a string (although, again, doesn't change the data actually saved in table).