Re: Query calc # days -- MIDRANGE-L

Yeah, I usually do something like casting that first character to some kind of numeric type, then multiply by 100 and add to 1900. This works in recent versions of SQL, can't remember if it got into Query/400

Alternatively, forget about that century digit and trust the system's 100-year window, then use a DATE function to get the 4-digit year format.

Vern

At 10:18 AM 3/3/2003 -0500, you wrote:

Mighty tough to do IF statements in a Query result field.
If C=0 then year =19+...
else year =20+...

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin


Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
02/28/2003 06:39 PM
Please respond to Midrange Systems Technical Discussion

        To:     Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxx>
        cc:
        Fax to:
        Subject:        Re: Query calc # days


Probably need to use DIGITS or CHAR function, then substring and
concatenate

Vern

At 05:16 PM 2/28/2003 -0500, you wrote:

>I can't figure out how to make that 7 digit date work.
>
>I looked at the help and see something like:
>DATE:
>          Syntax for:     DATE(expression)
>          Example of:     DATE(CHARDATE)
>     The DATE function returns a date from a value.
>...
>, or a character
>     string of length 7.
>
>Why that?
>
>If you can build another logical file over that I can whip up a fix in a
>hurry.
>
>Rob Berendt
>--
>"They that can give up essential liberty to obtain a little temporary
>safety deserve neither liberty nor safety."
>Benjamin Franklin
>
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
>To post a message email: MIDRANGE-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/midrange-l
>or email: MIDRANGE-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.