We renewed our MyDBR license, and subsequently had to update to 4.0 as well.
We run PHP/Apache on a Windows Server with MS SQL Server Express.
The update and subsequent switch from php_mssql to Microsoft's php_sqlsrv was done, and MyDBR runs fine after this update.
All except for one issue: Reports that use date filtering return no results.
To run through it we take input by using
'vStartDate=-1','vEndDate=-2' as required user parameters, the usual stuff
in the report query's where-clause we use
where (v.ReportingDate between @vStartDate and @vEndDate)
Dates in the database are formatted like so: 2013-06-01 00:00:00.000
And this has always worked in the past, and still seems to match the new date picker formats.
For some reason since the 4.0 update, the date filtering is not working.
Other reports with passed parameters are functional, so i'm ruling out mssql/sqlsrv differences... so I suspect the issue is with date formatting?
Any assistance will be appreciated!