change a field to null

[Dario2005]

hi

i have my crystal report which is right but all of the dates which should be null are coming back as a default "01/01/1975" this is not crystal but the program i have converted the data from... I cant go back to the old data now so, i somebody to please help me with a formula which will turn this date to a null... its just for one field.

Thanks in advanced.

 

[Dario2005]

i am using crystal 8

 

[dgillz]

Do you have "convert null field values to default" turned on under file, options? If so turn it off.

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

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[Dario2005]

yeah it is turned off... cheers for the response though...
I think its probably just in need of some simple code but im not to familiar with crystal...

 

[dgillz]

So what do you want to display instead of 1/1/75?

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

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[Dario2005]

it should just be a NULL so it should really be blank.

 

[dgillz]

Format the field and click the X-2 button next to the supress checkbox and enter a formula:

Isnull({yourDateField}) or {YourDateField}=date(1975,1,1)

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

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[Dario2005]

im typing

Isnull({{tdsls048.t_invd}}) or {{tdsls048.t_invd}}=date(01/01/1753)

but its comin back

This field name is not known.

 

[Dario2005]

thanks mate it done

 

[dgillz]

try Date(1975,1,1)

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

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown