Postdated checks and the InMonthToDate and InYearToDate functions.

[Larry_Aaron]

We have normally use Today() as the basedate for the InMonthToDate(date, basedate, shift) and InYearToDate functions, but have found some check postdating when attempting to validate payroll. What are some other ways of handling this senerio. Ideas thus far are to use Today() + 5 or some other reasonable number or to use Max(payroll_date) as the basedate.

At first venacular was an issue so I looked up postdated...

In banking, postdated refers to checks which have been written by the drawer for a date in the future. In the United States postdated items are described in Article 3, Section 113 of the Uniform Commercial Code. ^[1] Postdated checks are often used in conjunction with payday loans (from Wikipedia http://en.wikipedia.org/wiki/Post-dated_check)

Larry Aaron

larry.aaron@mcgladrey.com

[johnw]

OK, so payroll may postdate checks. All you know is the date on the check. You WANT to know what month and year the check was WRITTEN in?

Is the payroll department postdating to a particular day of the week, like Friday? Or are they just randomly postdating checks?

If there's a pattern, you didn't tell us the pattern, so we cannot solve the problem for you.

If there's no pattern, the problem is unsolvable. On September 30, 2010, I wrote two checks. One I didn't postdate, and one I postdated to October 3, 2010. If all you know is the date on the check, you cannot know when I wrote these checks.