Crystal Report String required in calc

Hi.  I created a report using Crystal Reports Developer v.11.5 over a SQL database.  I recently swiched servers and am getting an error on one of my report calcs.  both servers are Windows Server 2008 R2 and are running SQL 2012.    
Calc is: {VMI_WC_PRIO.START_DT}<= CurrentDate + 30     error is:  A string is required here.

Error is in the command.  Is this currentdate formula no longer valid?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

It sounds like the new server has the date field as a string.

Open the report and do a VERIFY DATABASE on it.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
valmaticAuthor Commented:
HI.  I verified and it came up with a map window so I unchecked "same type" and I was able to map my report field to the database field in the map window.  The database verified and said it was fixed but then took me to the formula window and said "A String is Required Here".  The "CurrentDate + 30"  portion of my formula is highlighted when this msgbox appears.   thanks
What type does Crystal think the date field is?  

You may have to remove the test to run the command.

When you are in the Crystal editor you can see what type the field is in the field explorer.

valmaticAuthor Commented:
Thanks.  I decided to go a different route on this though and just rebuilt the SQL view with my calc in it.  Solved my issue anyway..  Enjoy the points but keep me in mind if you see my name.  I'm fairly new to both SQL server and Crystal so I'm sure I'll have other questions..  cheers.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.