Microsoft access first day of week

Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Skip to main content. Looking For Assistance or Customizations?

Are you looking for a developer to help you develop an Access Database, Web Application, Add-in, or some other solution? Contact me and see how I can help. Leave a Reply Cancel reply Your email address will not be published. Like most sites on the Internet, this site uses cookies to collect data on usage comments, downloads, post views, etc… to improve your experience. By continuing to browse this site you consent to this policy. You assume the risks if you choose to try any of the code, samples, etc Returns a Variant Integer containing a whole number representing the day of the week.

Weekday date [ , firstdayofweek ]. Variant, numeric expression, string expression, or any combination of these that can represent a date. If date contains Null, Null is returned.

A constant that specifies the first day of the week. If not specified, vbSunday is assumed. The firstdayofweek argument has these settings:. If the Calendar property setting is Gregorian, the returned integer represents the Gregorian day of the week for the date argument. If the calendar is Hijri, the returned integer represents the Hijri day of the week for the date argument. Returns the values from the field "DateofSale" and number representing the 'Weekday' of these date values.

By default Sunday is considered the first day of the week; 1. For more information about working with VBA, select Developer Reference in the drop-down list next to Search and enter one or more terms in the search box.