Passing Formulae from VB to Crystal

[Theadmans]

I have a VB6.0 application which runs some Crystal 8.0 Reports.

I have setup a Formula in my Crystal Report called DateRange.

In my VB code I am trying to now setup this formula as a String Variable (DateRangeVar) which I have already setup. Here is the line of code I am using:-

MyReport.FormulaFields(GetFormulaIndex(MyReport, "DateRange")).Text = DateRangeVar

However, when I run this I get the error Crystal Report Viewer "The Remaining text does not appear to be part of the formula".

If I use exactly the same syntax to setup up a formula with a Table Field instead this works fine. Can anyone see what I am doing trying to setup a Formula as a String?

 

[Theadmans]

I have solved this now - need to use syntax like:-

DateRangeVar = "'01 January 2006 - 31 July 2006'"

I did need realise the need for the double quotes followed by the single quotes.