• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 153
  • Last Modified:

day of the week

how do i get the day of the week e.g."Tuesday"
0
FeVeR
Asked:
FeVeR
  • 2
1 Solution
 
Ryan ChongCommented:
Try:

MsgBox WeekdayName(Weekday(Now()))

cheers
0
 
FeVeRAuthor Commented:
that's great but it said wednesday, not tuesday
0
 
FeVeRAuthor Commented:
it's all good

WeekdayName(Weekday(Now(), vbUseSystemDayOfWeek))


worked thanks for that!
0
 
sazhagianambiCommented:
Hi,

WeekdayName(Weekday(Now()))
I don't think this'll show Wrong Day, Anyway,

MsgBox WeekdayName(Weekday("1-Apr-2003"))

Try out This-it'll Perfectly show as Tuesday

Nambi
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now