in vba for access how do i get the day of the week for a date field?

  • Thread starter Thread starter Daniel
  • Start date Start date
You mean Monday, Tuesday,...

Dim myDate As Date
myDate = DateSerial(2005, 12, 25)
MsgBox Format(myDate, "dddd")

or the day portion of the date?

Dim myDate As Date
myDate = DateSerial(2005, 12, 25)
MsgBox Day(myDate)
 
Back
Top