Date validation (if today - 1 week then)

[morlan]

Sorry for another Date validation question.

I've done some searching but I cant find what I'm loooking for.


I need a validation rule that would make sure the date entered was not older that 1 week from todays date.

I have a field 'txtDateTimeKeyed' which contains the current date and time from the SQL server so I wont be using now()

Please can you help?

 

[Mile-O]

How about this?

Between txtDateTimeKeyed And DateAdd("d", 7, txtDateTimeKeyed)


or some such variation.

 

[namliam]

*GRMBL*

You and your dateadd... *SIGH*

txtDateTimeKeyed+7

Will do the same...

Regards

 

[morlan]

Thank Mile, how do I implement this in VB? Or is it just for SQL?

EG. Is it like:

IF ME.txtAppDate.Value Between txtDateTimeKeyed And DateAdd("d", 7, txtDateTimeKeyed) then "TO OLD"

 

[namliam]

IF ME.txtAppDate Between txtDateTimeKeyed And DateAdd("d", 7, txtDateTimeKeyed) then Msgbox "TO OLD"

But you can also put the between bit directly as a validation rule.

Regards

 

[Mile-O]

"TO OLD"

TOO OLD

 

[morlan]

The vb is not liking the BETWEEN bit. Is says: Compile error. Expected Then or Goto? Any ideas

 

[Mile-O]

Between And is an SQL syntax.

If Me.txtAppDate > = txtDateTimeKeyed And _
    Me.txtAppDate <= DateAdd("d", 7, Me.txtDateTimeKeyed) Then
    Msgbox "TOO OLD" 
End If

 

[morlan]

Thanks M8