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
D

Daniel

in vba for access how do i get the day of the week for a date field?
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

week numbers 3
date format into day of week 13
Fill series (weeks) 3
Excel How to get the number of days an item was opened from the today's date. 14
how to get the number of days between two date formatted fields in vba for excel? 1
Access Property sheet data missing also syntax 0
Year + week => first date of week 9
Monthly Summary of days of the week ? 3

Back
Top