string required message on datetime formula's

[mbutch]

I'm using SCR 8.5 Dev with the latest hotfix and I'm having a big problem with formulas that use a datetime field. I keep getting "A string is required here." and "Bad String Format" error messages on all datetime related formulas and selections on existing reports (that used to work). If I create a new report, the datetime formulas work fine, but if I change the data location from development to production they stop working. What has this hot fix done to me? Is anyone else having similar problems?

Thanks.

 

[synapsevampire]

Are you certain that it doesn't have something to do with the connectivity or database differences?

If you point to Prod and do a verify database, what happens?

-k

 

[mbutch]

It says the database is up to date.

I think it is a bug related to one of the hot fixes I installed. The reports I started noticing this issue on are ones that have always worked and haven't been modified for months. They still work on clients with a viewer, but not on my dev machine.

 

[mbutch]

Hotfixes I installed for 8.5:
SP1
ACTXVIEWWIN_EN_200303.EXE (ActiveX)
DBEXDRVRWIN_EN_200303.EXE (Database and Export)
CR85DEVWIN_EN_200303.EXE (developer Files)
RPTVIEWRWIN_EN_200302.EXE (Java Viewer)
CR85MAINWIN_EN_200303.EXE (Main Program)
CR85olap0702-EN.exe (olap)