Formula Field and Dates

[staleb]

In my application I pass my values into Formula fields dirctly:
reportObject.DataDefinition.FormulaFields("Formula Filed").Text = "input box".text

And my formula:
formula = table.field

When I does this with dates I get this error mesage:

Error in formula <Dato>.
'01.02.1999'
The remaining text does not appear to be part of the formula."

Does anyone have a clue whats wrong?

 

[synapsevampire]

Show how you're passing the date, not just the error.

Sounds like you're passing the wrong format to me.

Here's the whitepaper on creating reports and formulas using the RDC:

http://support.businessobjects.com/library/kbase/articles/c2007183.asp

-k

 

[staleb]

This is how I send my data.

reportObject.DataDefinition.FormulaFields("Formula Filed").Text = "input box".text

Where "input box".text is the data entered by the user

 

[staleb]

I found a soulution:

Crystal wouldn't let me convert the srting I sent in, becaus it didnt reqonize it as an string.

The value that I sent in was: 02.02.2005 'dd.mm.yyyy

What I needed to do to get CR to understand that this is a text was: chrW(34) + inputbox.text + chrw(34)
Which made my text appear like this "02.02.2005" and then CR could turn it into a date