Re: Date Variables

[Arturo Vega <arturo_vega-consultant@PEOPLESOFT.COM>]

Hello to all, this is my first mail in the list and is only to tell kenny
that you can't compare two strings (you see dates but in sqr are string
variables).  You must use date variables OR convert your dates to YYYYMMDD
format  (in PeopleSoft id DTU-DATE-FORMAT) so you can compare first year,
than months and at the end the days.

if you are using PeopleSoft applications use convert-to-dtu-date to format
your string in dtu-format YYYYMMDD and use convert-from-dtu-date to leave
it in native format.

Please sorry about my english, and greetings from Mexico to everyone

Arturo Vega
PeopleSoft Consultant
HRMS - Mexican Payroll Product



Hello Everyone,

I am using SQR 4.3.4 and am having a strange problem (or a severe brain
burp).  Can anyone tell me why the following works the way it does?:

BEGIN-SETUP
    DECLARE-VARIABLE
        DATE  $MINDATE
        DATE  $MAXDATE
    END-DECLARE
END-SETUP

BEGIN-PROCEDURE COMPARE-DATES
    LET $MAXDATE = '01-SEP-1999'
    LET $MINDATE = '31-AUG-1999'

    SHOW 'MAX DATE = ' $MAXDATE
    SHOW 'MIN DATE = ' $MINDATE

    IF $MAXDATE = $MINDATE
        SHOW 'MAXDATE = MINDATE'
    END-IF

    IF $MAXDATE <> $MINDATE
        SHOW 'MAXDATE <> MINDATE'
    END-IF

    IF $MAXDATE > $MINDATE
        SHOW 'MAXDATE > MINDATE'
    END-IF

    IF $MAXDATE < $MINDATE
        SHOW 'MAXDATE < MINDATE'
    END-IF

END-PROCEDURE

The log file output looks like this:

MAX DATE = 01-SEP-1999
MIN DATE = 31-AUG-1999
MAXDATE = MINDATE

I'm kind of stumped on this one.  I think it has something to do with the
internal "string" representation of the date variables, but all my juggling
with the SQR.INI file settings didn't have any impact.  I have also tried
it
with the "MOVE" command in place of the "LET" command above and, again, no
difference.  Oh, one more thing -- this happens consistently when one of
the
dates is an end-of-month date, and the other date is the following
first-of-month date.  OK Gurus, what am I missing?

Thanks in advance,
Kenny Melton
Sr. Technical Architect
Tandy Information Services
PeopleSoft Financial Systems
kmelto1@tandy.com