Coding for specific dates in Crystal Reports

Below is an old tip from one of the GP Reports Viewer monthly newsletters. In the past few months I have had to look this up several times, because I just cannot seem to remember the syntax, so I thought I would put it on my blog, where it will be easier for to find for everyone, including me.  🙂

The situation where I last needed this was when I was creating a Crystal Report and wanted to hide a date field if it returns ‘1/1/1900’, the equivalent of a NULL in Dynamics GP data. To do this, follow the steps below:

  1. Right click on the date field on the report and choose Format Field
  2. On the Common tab click on the formula button next to Suppress
  3. Add the following formula, replacing DateField with yours: {DateField} = #1/1/1900#
  4. Click Save and Close, then OK.

If you would like to receive monthly tips like this, please subscribe to the GP Reports Viewer newsletter. And if you are looking to use Crystal Reports with Microsoft Dynamics GP, please check out GP Reports Viewer – it can make using Crystal Reports (or SSRS) in Dynamics GP a breeze.

4 Responses to “Coding for specific dates in Crystal Reports”

  1. Victoria,
    Does GP have sample Crystal Reports available for download to learn from?



  1. Coding for specific dates in Crystal Reports : Interesting Findings & Knowledge Sharing - September 18, 2012

    […] more here: Coding for specific dates in Crystal Reports VN:F [1.9.20_1166]Please wait while your rating is cast…Rating: 0.0/10 (0 votes cast)VN:F […]


  2. Coding for specific dates in Crystal Reports – 9/18, Victoria Yudin | Partner Compete - September 18, 2012

    […] Continue reading on Source Blog […]


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: