General discussion

  • Creator
    Topic
  • #2188865

    Evaluating Oracle Null Date in Crystal

    Locked

    by spiderdad ·

    I am using Crystal Reports in Visual Studio 2003.
    I am unable to evaluate a null date/time in a formula field. All I want to do is :
    If date is null
    then “No”
    else “Yes”;
    My unsuccessful attempts :
    1. “Is Null” errors out looking for a “Then” even though I have one.
    2. I tried converting the date to text and checking if it’s length > 0.

All Comments

  • Author
    Replies
    • #3044222

      Reply To: Evaluating Oracle Null Date in Crystal

      by emargel ·

      In reply to Evaluating Oracle Null Date in Crystal

      I am not familiar with Crystal but I have run into this issue with MS Access. In Access my code would look like this.

      if isnull(date) then
      “NO”
      else
      “YES”
      end if

      In your code if Crystal supports the term ‘if date is null’ I would try moving ‘then’ onto the same line otherwise check if you are using the correct syntax to determine if the date is a null value.

    • #3137528

      Reply To: Evaluating Oracle Null Date in Crystal

      by spiderdad ·

      In reply to Evaluating Oracle Null Date in Crystal

      This question was closed by the author

Viewing 1 reply thread