<div>
You can use this expression:<br />
<br />

<pre><code id="code-20-42774107-1">DayOfWeek = 1 + (Weekday(Date, vbSunday) - Weekday(Date, vbUseSystemDayOfWeek) + 7) Mod 7</code></pre>
If, say, it is Monday, the result will be 2, the numeric value of <i>vbMonday</i>.
</div>


You can use this expression:



DayOfWeek = 1 + (Weekday(Date, vbSunday) - Weekday(Date, vbUseSystemDayOfWeek) + 7) Mod 7

If, say, it is Monday, the result will be 2, the numeric value of vbMonday.

<div>
Maybe I don't understand you correct :) - But im not looking for the first day of the week - it's the firstweekofyear set in the NLS
</div>


Maybe I don't understand you correct :) - But im not looking for the first day of the week - it's the firstweekofyear set in the NLS

Consultant

Mik Mak

<div>
Thank you for the ISO function - but I was actually looking for a some way to &quot;read&quot; the NLS API setting &nbsp;on the current system - I have som differences running on different systems - but the ISO way could be a way of streamlining it I guess :)
</div>


Thank you for the ISO function - but I was actually looking for a some way to "read" the NLS API setting  on the current system - I have som differences running on different systems - but the ISO way could be a way of streamlining it I guess :)

<div>
Thank you very much for the fast and excellent responses
</div>


Thank you very much for the fast and excellent responses

<div>
Excellent ! - thank you very much !
</div>


<div>
<div class="content wysiwyg-content">
In Access VBA function DateDiff- the firstweekofyear parameter can be set to vbUseSystem - but where can I check what the NLS API setting is set to ?
</div>
</div>


In Access VBA function DateDiff- the firstweekofyear parameter can be set to vbUseSystem - but where can I check what the NLS API setting is set to ?

Where to find NLS API setting for firstweekofyear

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.