<div>
That code is prone to localization errors if used in regions (or on computers) where the dateformat doesn't match the US date format.<br />
The following should work &nbsp;in all regions:<br />

<pre><code id="code-20-41992729-1">DCount([id],[Tbl_ClientCommunication],&quot;[calcdate] &lt;Date()&quot;)</code></pre>
In Bill's code, the Date is first interpreted by VBA, and formatted according to regional settings. In the second case, the date() is called directly by the database engine, and you avoid any regional issues.
</div>


That code is prone to localization errors if used in regions (or on computers) where the dateformat doesn't match the US date format.
The following should work  in all regions:


DCount([id],[Tbl_ClientCommunication],"[calcdate] <Date()")

In Bill's code, the Date is first interpreted by VBA, and formatted according to regional settings. In the second case, the date() is called directly by the database engine, and you avoid any regional issues.

<div>
Sorry Bill. Anders is right. Your code will fail on this side.<br />
<br />
/gustav
</div>


Sorry Bill. Anders is right. Your code will fail on this side.

/gustav

<div>
<div class="content wysiwyg-content">
This should be straight forward but it isn't. &nbsp;I am trying to count the number of records in a table where the date in a field is less than the current date. &nbsp;What I have is the below but it is kicking out an error code.<br />
<br />
=DCount([id],[Tbl_ClientCo<wbr />mmunicatio<wbr />n],&quot;[calcd<wbr />ate] &amp;&nbsp;Date()&quot;)<br />
<br />
Does anyone know how to write this so it works?
</div>
</div>


This should be straight forward but it isn't.  I am trying to count the number of records in a table where the date in a field is less than the current date.  What I have is the below but it is kicking out an error code.

=DCount([id],[Tbl_ClientCommunication],"[calcdate] & Date()")

Does anyone know how to write this so it works?

Dcount using a date in a table compared to today's date

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

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

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.