ANSWERS: 1
-
Try this: Dim dt As Date dt = #1/9/2008# MsgBox Format(dt, "mmmm dd,yyyy") MsgBox Format(dt, "YYMM") & Weekday(dt) I haven't been able to drop the leading zero off of "08".
Copyright 2023, Wired Ivy, LLC