I'm tring to format the date as: 04242001
i tried

DatePart("m", Now)



any ways of getting the entire thing?