Date manipulation trick required.

[hooi]

I have an original date (mm/dd/yyyy) such as: 6/01/2003. I'd like to use macro/query to change the date to a month based on another date field (eg. 7/15/2003), so that the result for the original date will become 7/01/2003.

Any help would be appreciated. Thanks...

 

[Mile-O]

Have a look at these functions in the help files:

Day()
Month()
Year()
DateValue()
DateSerial()
TimeValue()
TimeSerial()
IsDate()

 

[hooi]

Thanks...

 

[MadMaxx]

Wouldn't it be easier to make the format consistant over your entire program. It's a good programming practice

*EDIT*

Nevermind. It's early and my brain farted