When searching a foundset for records having a specific date expression, the records returned contain those dates in the expression PLUS one extra day. Below is a code snippet asking for records having a billing date on or prior to 02/29/2016.
- Code: Select all
if ( fs.find() )
{
fs.billing_date = "<=#02/29/2016|MM/dd/yyyy"
fs.search()
...
}
The very first record in the resultant foundset has a billing date of 03/01/2016 (and there are a few others). Below is a screen shot from the debugger showing the billing date of that first record.
<edit>
This is happening throughout our solution in non-related areas. Has anyone else come across this?