C CharlesWhiteman Registered User. Local time Today, 08:38 Joined Feb 26, 2007 Messages 421 Apr 16, 2011 #1 Does anyone know how to find out what day of the week it is using VBA? Thanks
gemma-the-husky Super Moderator Staff member Local time Today, 08:38 Joined Sep 12, 2006 Messages 16,121 Apr 16, 2011 #2 weekday(date) returns a number in the range 1 to 7 constants for these days are vbsunday, vbmonday etc does that help?
weekday(date) returns a number in the range 1 to 7 constants for these days are vbsunday, vbmonday etc does that help?
C CharlesWhiteman Registered User. Local time Today, 08:38 Joined Feb 26, 2007 Messages 421 Apr 16, 2011 #3 Hi, I am not sure if that helps. Basically I am developing a query which (based on an if) will only run on a specific day of the week. So, I need to identify in a query what day it is "today"
Hi, I am not sure if that helps. Basically I am developing a query which (based on an if) will only run on a specific day of the week. So, I need to identify in a query what day it is "today"
DCrake Remembered Local time Today, 08:38 Joined Jun 8, 2005 Messages 8,626 Apr 16, 2011 #4 Today:Format(Date(),"dddd") = Saturday
C CharlesWhiteman Registered User. Local time Today, 08:38 Joined Feb 26, 2007 Messages 421 Apr 16, 2011 #5 That did it! Thanks