H
H0MELY
Greetings, thank you very much for looking at my post. I am hoping that
someone will be able to help me assign a month value to an invoice based upon
its period_begin_date and period_end_date. Assigning the month is easy when
the the two dates occur in teh same month (1/1/08 to 1/31/08) but the problem
I hope you can solve for me is when the begin and end dates are in two
seperate months (4/28/08 to 5/4/08).
What determines the month of the invoice on dates such as 4/28/08 to 5/4/08
is the number of weekdays in each month. So for an invoice dated as above it
would be considered an April Invoice...4/28 (Mon), 4/29 (Tue), 4/30 (Wed),
5/1 (Thur) and 5/2 (Fri)...or 3 weekdays in April and only 2 weekdays in May.
So here is where I am getting stuck...I need to automate this process so
that when the invoice summary (vendor_name, Invoice_number,
period_begin_date, period_end_date and invoice_total) is imported into access
and I assign a Billing Month to the data...those invoices that span 2 months
are assigned to the correct month.
Currently I am assigning a month to both the begin and end dates and then
doing an Iif statement comparison to identify all of the invoices contained
within a month (begin and end date are in the same month and year) I then
manually adjust the invoices that are not contained within a singular month.
This works...but is time consuming.
Any guidance would be VERY VERY VERY appreciated. Thanks again to everyone
for looking.
-John
someone will be able to help me assign a month value to an invoice based upon
its period_begin_date and period_end_date. Assigning the month is easy when
the the two dates occur in teh same month (1/1/08 to 1/31/08) but the problem
I hope you can solve for me is when the begin and end dates are in two
seperate months (4/28/08 to 5/4/08).
What determines the month of the invoice on dates such as 4/28/08 to 5/4/08
is the number of weekdays in each month. So for an invoice dated as above it
would be considered an April Invoice...4/28 (Mon), 4/29 (Tue), 4/30 (Wed),
5/1 (Thur) and 5/2 (Fri)...or 3 weekdays in April and only 2 weekdays in May.
So here is where I am getting stuck...I need to automate this process so
that when the invoice summary (vendor_name, Invoice_number,
period_begin_date, period_end_date and invoice_total) is imported into access
and I assign a Billing Month to the data...those invoices that span 2 months
are assigned to the correct month.
Currently I am assigning a month to both the begin and end dates and then
doing an Iif statement comparison to identify all of the invoices contained
within a month (begin and end date are in the same month and year) I then
manually adjust the invoices that are not contained within a singular month.
This works...but is time consuming.
Any guidance would be VERY VERY VERY appreciated. Thanks again to everyone
for looking.
-John