<div>
not really sure what you are trying to accomplish here, but,<br />
<br />
try something like this<br />
<br />
IIf([type]=&quot;JBIC&quot;,&gt;Date()+<wbr />30,&lt;Date()<wbr />+25)
</div>


not really sure what you are trying to accomplish here, but,

try something like this

IIf([type]="JBIC",>Date()+30,<Date()+25)

<div>
if you are using A2010 or greater, data macro may work for you..
</div>


if you are using A2010 or greater, data macro may work for you..

<div>
thank you. &nbsp;I will try the validation rule at the form level.
</div>


thank you.  I will try the validation rule at the form level.

<div>
<div class="content wysiwyg-content">
Experts, in a validation rule, can I refer to field within the table? &nbsp; I am referring to [Type] within the field &nbsp;[ExpectedDisbRecdDate]. &nbsp;Not sure if a rule like this is better placed in a form.<br />
<br />
for example: <br />
<br />
if [type] = &quot;JBIC&quot;,&gt;Date()+30,&lt;Date()+<wbr />25<br />
the error I get is &quot;enclose text data in quotes&quot;<br />
<br />
thanks<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/09_w36/870237/Untitled.jpg" target="_blank" title="ValidationRule (83 KB)"><img alt="ValidationRule" class="file-block lazyload" style="max-width: 501px;" data-src="https://filedb.experts-exchange.com/incoming/2014/09_w36/870237/Untitled.jpg" /></a>
</div>
</div>


Untitled.jpg

Experts, in a validation rule, can I refer to field within the table?   I am referring to [Type] within the field  [ExpectedDisbRecdDate].  Not sure if a rule like this is better placed in a form.

for example: 

if [type] = "JBIC",>Date()+30,<Date()+25
the error I get is "enclose text data in quotes"

thanks



Validation Rule

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.