get date in access

[danlindley]

Is it possible (notices is using forum a lot) to do a get date action in access to compare to a date already stored in a date field and have a message box appear if the date is the date stored or after??

Thanks

Dan

[vass0922]

You'd have to write a short vba module to do it behind the form.

very easy to write though
basically

Get Date1
Get TodayDate
If date1 > TodayDate
MsgBox "Yep its later than today"
Else
MsgBox "Nope, it happened previous to today"
End If

[danlindley]

Thanks Vass;

Erm thanks, but it doesn'y seem to be working, as i amnot fmailiar with VB.

Get Date1 <-appears in red
Get TodayDate <-appears in red
If date1 > TodayDate <-appears in red
MsgBox "Yep its later than today"
Else
MsgBox "Nope, it happened previous to today"
End If

The date i want is in table "personal details" and is vcalled "requal date" how would i use this field in your script?? I need to get the days date, and minus a month, and compare the two, so that a reminder is issued if the Requal date is within a month of the actual date.

Thanks again for your help.

Dan