Dynamic replace 2

[Regelos]

I'm wondering if there is a way to use crystal to replace a value 12/30/1899 with unknown. Thanks

 

[lbass]

What do you want to replace the date with? If you want a blank field, use:

if {table.date} = date(1899,12,30) then date(0,0,0)

-LB

 

[dgillz]

12/30/1899 typically displays as a date whem the date field is null or zero.

So test for this:

If Isnull({YourField}) or {YourField}=Date(0,0,0) then "unknown" else totext({YourField})

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

http://www.gainfocus.biz

 

[Regelos]

do I do this in a query? and I just want to make shure this will only display and not replace the orginial data because if I replace the data I will break the whole enterprise LOL

 

[synapsevampire]

Crystal can't replace data unless the driver allows for it and you go outside of the conventional Crystal GUI for data retrieval and issue a SQL statement to in some way alter data.

Were you to have posted basic technical information, you may have learned that you could use a SQL Expression and have the database return what it is you want, or you might even use Report->Options->Convert null values to default.

Please remember to post meaningful information in future posts:

Crystal version
Database/connectivity used
Example data
Expected output

-k

 

[Regelos]

I'm using Crystal 11

OBDC through SQL Report is based off a complex query.

data and expected output are contained above

I get 12/30/1899 and would Like to have the output be Unkown or with more thought into it Not Synced

 

[Regelos]

I got it to work with
If Isnull({WAS_Remote_Proccessing.Last_Date}) or {WAS_Remote_Proccessing.Last_Date}=Date(1899,12,30) then "Never Synced" else totext({WAS_Remote_Proccessing.Last_Date})

in crystal 11 buyt now the normal dates are back displaying as
2/2/2006 12:00:00AM and I dont want the time to show any suggestions?

 

[lbass]

If Isnull({WAS_Remote_Proccessing.Last_Date}) or {WAS_Remote_Proccessing.Last_Date}=Date(1899,12,30) then "Never Synced" else totext({WAS_Remote_Proccessing.Last_Date},"MM/dd/yyyy")

If you only want one digit per month/day, then change it to "M/d/yyyy".

-LB

 

[Regelos]

thanks a ton this is EXACTLY what I need