Our problem is that: We need to bill in the same month item is shipped, provided the billing cut off is prior to the shipping date. Example, billing cutoff is on the 10th, shipping is on the 20th. (I can handle that part) where I have a problem is when it is in the next month. I’m pulling the day shipped with a formula, compairing with less than or = to, and flagging “need to bill”. I’ve included a “and” for shipping date greater than 0, but have a problem if billing cuts of on the 10th, product ships june 20 2008 and it’s april 15th. return value says need to bill. I only need it to bill if it (cut off is prior to shipping date, shipping has been set, AND is in “current” month). (don’t want to bill for next month or the month’s after). Anyone have any Ideas?
