Verify Date Validation Rule

[LizzleJ]

I'm sure this is on the forum somewhere but have searched and searched... and had no luck.

I want my date feild to be set to enter a date no more than 2months in advance but a minium of a week in advance.

I have done this lol

week(1)<"">month(2)

I don;t actually have a clue, do you use "" to represent the value? also how do i do this date verify thing .

Thanks in advance

 

[hardyd44]

verify date

Hi,

just done something simular - is the user entering a date and you want to verify that it is between those paremters ?

if its on a form just use vb along the lines
If (Me.Date.Value) < (Me.StartDate.Value) Then
MsgBox "Date before start of period!!", vbOKOnly, "Incorrect Date"
Exit Sub
Else
End If
If (Me.Date.Value) > (Me.enddate.Value) Then
MsgBox "Date after end of Period!!", vbOKOnly, "Incorrect Date"
Exit Sub
Else
End If

where startdate = now() + 7 (1 week)
and enddate = Now() +60 (2 months)

I used hidden fields to calculate the start and end dates for my use, but I am sure someone will come up with something more elegant

Dean