<div>
<div class="content wysiwyg-content">
What is the correct syntax for the following:<br />
&nbsp;<br />
I am trying to write a query which evaluates whether today's date is between two dates - - if so, then perform a calculation, else Null. &nbsp;I'm having trouble with the date syntax.<br />
<br />
This is what I have tried:<br />
<br />
<br />
Expr: &nbsp;IIf(Date() &gt;&nbsp;#[BeginningDate]# and &lt;&nbsp;#[EndingDate]# , [PerformCalculation] ,Null)<br />
<br />
<br />
Thank you.
</div>
</div>


What is the correct syntax for the following:
 
I am trying to write a query which evaluates whether today's date is between two dates - - if so, then perform a calculation, else Null.  I'm having trouble with the date syntax.

This is what I have tried:


Expr:  IIf(Date() > #[BeginningDate]# and < #[EndingDate]# , [PerformCalculation] ,Null)


Thank you.

Syntax for Access Query using Dates

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.