Re: Odd Error: Month must be between 1 and 12

[D E <wirebird1@HOTMAIL.COM>]

Andrew,

I would think that invoicedate isn't null.  The field must contain a space
or similar character.  Perhaps you could use length() to determine your if
statement:

If length(&invoicedate) < 2 (or 3 or 4 whatever is appropriate)
          show 'invoicenum: ' &invoicenum ' is NULL'
       else
          show 'invoicenum: ' &invoicenum ' - Invoicedate: '
End-If

David


>From: Andrew Rivers <andrew.rivers@CWCOM.NET>
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: Odd Error:  Month must be between 1 and 12
>Date: Thu, 24 Jan 2002 15:21:52 +0000
>
>Hi
>I get the error:
>Error on line 1377:
>    (SQR 1925) Month must be between 1 and 12.
>
>Line 1377 is as follows (all on one line):
>     show 'invoicenum: ' &invoicenum ' - Invoicedate: '  &invoiceDate
>
>The problem is a NULL value for &invoiceDate in the database.
>      select invoicenum, invoicedate from invoice
>             where invoicenum = '1052' and invoicedate is null;
>This returns:
>      INVOICENUM     INVOICEDATE
>      ========== ====================
>      1052
>
>      1 ROW SELECTED
>showing that invoicenum = '1052' is NULL.
>
>However, if the following code is run:
>       if  isnull( &invoiceDate )
>          show 'invoicenum: ' &invoicenum ' is NULL'
>       else
>          show 'invoicenum: ' &invoicenum ' - Invoicedate: '  &invoiceDate
>       end-if
>
>the else statement is executed for invoicenum = '1052' and the program
>terminates at:
>       invoicenum: 1052 - Invoicedate:
>
>Other fields including date fields do not give problems.
>
>If anyone has any suggestion as to the problem, I would be most grateful.
>
>Andrew




_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.