Error in Formula

[psmani]

Hi,
I have one more problem in accessing crystal reports, when i try to access a crystal report its giving me a runtime error saying that "Bad date format string" in one formula. Actually in that formula the following code is written

if not isnull({@rMajDateOfPrice}) then
if Year (Date({@rMajDateOfPrice})) = 1941 then
1
else
0

rMajDateOfPrice is actually a nvarchar field in database, thats the reason i am converting to date and then getting the year

Any suggestions for this.....

Thanks in advance

Regards
Manikandan

 

[zemp]

The Date() function usually returns the currect date. To convert a string type to a date type use the CDate() function. Try,


if not isnull({@rMajDateOfPrice}) then
if Year (CDate({@rMajDateOfPrice})) = 1941 then
1
else



Thanks and Good Luck!

zemp

 

[lbass]

You are showing a formula {@rMajDateOfPrice} not the field {rMajDateOfPrice} in your formula above. So what is in your formula {@rMajDateOfPrice}?

-LB

 

[synapsevampire]

zemp: You're mistaken, date returns the same as cdate and datevalue.

LB is correct, you're not using a database field, you're using a formula.

It might be simpler to not worry over converting to a date, and just pull the value you need from the string, as in:

val(left({rMajDateOfPrice},4))

I try to use SQL Expressions to handle this sort of thing as then the work is offloaded to the database.

-k