By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,931 Members | 1,247 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,931 IT Pros & Developers. It's quick & easy.

Calculate Date Difference and display message box

P: n/a
I have a table used to enter the last date a project was updated.

When updating via a form, I need to compare the new date against the
last date in the record. If the difference is greater than 14, I need
to display a message box alerting the user. Secondly, they must then
enter comments in the comment field explaing the varience.

I'm not sure how to get the last value and compare it to the current
value.

Any help would be greatly appreciated.

Thank You,

Jimmy

Dec 31 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
jbsfe wrote:
I have a table used to enter the last date a project was updated.

When updating via a form, I need to compare the new date against the
last date in the record. If the difference is greater than 14, I need
to display a message box alerting the user. Secondly, they must then
enter comments in the comment field explaing the varience.

I'm not sure how to get the last value and compare it to the current
value.

Any help would be greatly appreciated.

Thank You,

Jimmy


DMax("DateField", "TableName", "Criteria (if needed)")

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Dec 31 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.