Greater than statement

  • Thread starter Thread starter bladelock
  • Start date Start date
B

bladelock

I'm comparing two date values, I want to make sure the user does not go type
over 7 days from the dates entered. Example the user enters [Triage
dte]=01/01/2008 [reg dte]= 01/20/2008. I need to figure out how to make a
statement where the date is great that 7 days

I tried this but it's wrong:

If (Me![reg dte].Value > Me![triage dte].Value)+7 Then
<code>
<code>
End If

Any suggestions?
 
Your parentheses are incorrect.

If Me![reg dte].Value > (Me![triage dte].Value+7) Then

or

If Me![reg dte].Value > DateAdd("d", 7, Me![triage dte].Value) Then


Note that the .Value isn't strictly necessary, since the default property of
all text boxes is Value.
 
Back
Top