J
Joe Cilinceon
Here is some background first. I have a paidthru date say it is always the
last day of a month. Now I want to setup a formula in a query that will give
me the 10th day of the current month and compare it with the paid thru date.
Now if the paid thru date is say 12/31/04 and it is 1/10/05 I want the query
to add a late fee to the account. This is a balance due query.
At the moment I have a module setup that does the first and last days of a
given month based on the DateSerial. How would I set a dateserial to the
10th of a month.
last day of a month. Now I want to setup a formula in a query that will give
me the 10th day of the current month and compare it with the paid thru date.
Now if the paid thru date is say 12/31/04 and it is 1/10/05 I want the query
to add a late fee to the account. This is a balance due query.
At the moment I have a module setup that does the first and last days of a
given month based on the DateSerial. How would I set a dateserial to the
10th of a month.