[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Handling Null Dates?

Use the NVL($Variable, '') when inserting the value. See the SQR Reference
manual...

Bob Smith

> -----Original Message-----
> From: Discussion of SQR, SQRIBE Technologies's database reporting
> language [mailto:SQR-USERS@list.iex.net]On Behalf Of Shawn Robinson
> Sent: Monday, May 17, 1999 11:10 AM
> To: Multiple recipients of list SQR-USERS
> Subject: Re: Handling Null Dates?
>
>
> Do I have to use a 'dummy' date??  Fields like Termination Date, Last Date
> Worked, ReHire Date, shouldn't these be null for active employees??
>
> If I used a 'dummy' date, I guess I could then perform and update query to
> set the dummy date to null.  I would prefer to set the date to null the
> first time.
>
> Shawn R
>