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

Testing for time elapsed

P: n/a
I need to test each transaction listed in a Transaction table to find out if
, as of "today",at least 14 days have past since the date listed in the
"ClosingDate" field. If this is true I want to have a "yes" show up in a
field called "is commission eligible to be paid?"

I also may need to test for other conditions in order for the yes to show.

I am totally at a loss for the proper way to put the expressions together.
Any help would be greatly appreciated.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Thu, 30 Jun 2005 20:05:27 -0400, Barbara Warszycki wrote:
I need to test each transaction listed in a Transaction table to find out if
, as of "today",at least 14 days have past since the date listed in the
"ClosingDate" field. If this is true I want to have a "yes" show up in a
field called "is commission eligible to be paid?"

I also may need to test for other conditions in order for the yes to show.

I am totally at a loss for the proper way to put the expressions together.
Any help would be greatly appreciated.


Something like this in the control source of an Unbound control on a
form, report, or as an expression in a new column in a query:

=IIf(DateDiff("d",[ClosingDate],Date())>14,"Yes","No"))

This should not be stored in any table. Whenever you need the
information, run the calculation, as above.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.