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

Day function unable to work

I have a vb application that make use of the Day function in VB5 to retrieve the integer equivalent of the day of the week (e.g. 1 => Monday). It works perfectly in my computer (HP Vectra II)but unable to produce the desire result in another computer (Compaq Deskpro). Could it be solved? If not is there any alternative method to retrieve the day of the week without using the Day function.  
1 Solution
DAY does not give you the day of the week, but the day of the month. what you need is the WEEKDAY function.


MsgBox (WeekDay(Now, vbSunday))
oohchildAuthor Commented:
Yup bug solve, it is due to the weekday function, some computer give Monday to be 1 whereas other assign Monday as 2, which results in the inconsistency

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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