Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 462
  • Last Modified:

Suppressing a field in Crystal

Hello,
I have a date field that's has a value of 1900-01-01 00:00:00.000.How can I suppress the field if the data is like above.
Thanks.
0
Star79
Asked:
Star79
1 Solution
 
mlmccCommented:
Try this

Right click the field
Click FORMAT FIELD
Click the COMMON TAB
Click the FORMULA BUTTON to the right of SUPPRESS
Enter
Date({YourDateField}) = Date(190,1,1)
Click SAVE AND CLOSE
Click OK
Run the report

mlmcc
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now