Problem with formula:

[smtoomey3]

Can someone tell me what is wrong with this formula crystal keeps telling me I'm missing a (

if {OELINHST_SQL.shipped_dt}=0 then (DateToJulian(CurrentDate)) else {@ShippedDateJulian}

 

[dgillz]

I am assuming this is crystal....why are you using julian dates?

I see no problems with your formula however.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[kscheeler]

You could try it this way:

if {OELINHST_SQL.shipped_dt}=0 then
DateToJulian(CurrentDate) else {@ShippedDateJulian}

or use the NumberToDate function in Crystal and do this:

if {OELINHST_SQL.shipped_dt}=0 then
CurrentDate else NumberToDate({OELINHST_SQL.shipped_dt})


Kevin Scheeler