Re: Julian Day/Date Formatting

[Ben Le <ble@PCC.EDU>]

Linda,
SQR 4.3.5 is kind of old. Do not upgrade to 4.3.5, should go direct to
6.1.4. Just a suggestion!

At 05:36 PM 5/11/01 -0500, you wrote:
>Thank you for your replys to my request for info.  Here is what I found.
>
>This was an existing custom SQR that I had picked up to correct date format
>problems resulting from upgrade to 7.6 and SQR 4.3.4.     I had already
>changed all of the date variables to 'Convert-To-DTU-Date' format and was at
>a loss as to why it wasn't working when I sent out my email.  With the info
>that you all sent, confirming that 'Convert-To-DTU-Date' format was correct,
>I found that this SQR also had 'DATEADD with STRTODATE' compares and
>STRTODATE compare .  These lines of code also needed revision so that the
>result of DATEADD was put in 'Convert-To-DTU-Date' format before performing
>the compare and just removing the STRTODATE from another compare fixed it's
>problem.
>
>PeopleSoft did provide me with another piece of info on the bug introduced
>in SQR 4.3.4.  It's TPRD # = T-EMONTE-6L2DS, reported on Sept, 1999 and
>should be fixed in SQR 4.3.5.
>
>Thanks again,
>Linda
>___________
>Linda Krey
>PeopleSoft Application Specialist
>Office of Information Technology
>
>American Heart Association
>7272 Greenville Avenue
>Dallas, TX  75231-4596
>214.706.1459 (Voice Mail 1459)
>214.706.1211 FAX
>
> > -----Original Message-----
> > From: Peter Clark [SMTP:PGCLARK@VAC-ACC.GC.CA]
> > Sent: Friday, May 11, 2001 11:06 AM
> > To:   SQR-USERS@list.iex.net
> > Subject:      Re: Julian Day/Date Formatting
> >
> > Linda,
> >
> > In the DateMath.sqc there is a routine (Convert-To-DTU-Date) that converts
> > date format fields to the ISO-8601 international standard YYYY-MM-DD
> > format string variable. Dates formatted in this manner will always compare
> > correctly.
> >
> > e.g.
> > do Convert-To-DTU-Date(&A.Date1,$DateOne)
> > do Convert-To-DTU-Date(&B.Date1,$DateTwo)
> > if $DateOne > $DateTwo
> >   do something
> > end-if
> >
> > This is how we addressed the SQR bug. Worked like a charm.
> >
> > HTH, Peter
> >
> > >>> Linda Krey <linda.krey@HEART.ORG> 2001/05/11 12:38:29 pm >>>
> > From prior postings, I understand that there is a known bug with 4.3.4
> > when
> > comparing two dates where one date is the end of a month and the other
> > date
> > is the beginning of the next month.   SQR 4.3.4 does not recognizing that
> > there is a difference between the dates.  (example:  If 2001-01-01 is >
> > 2000-12-31 then do something.  In this case, the do something never
> > happens.
> > The nothing happening is causing data to not appear in interfaces/reports,
> > etc.).
> >
> > For the sake of speed of resolution, does anyone have julian day/date
> > formatting routines that they would share with me?  I have been
> > unsuccessful
> > finding these formatting routines in the PeopleSoft delivered SQCs.
> >
> > Also, is there a web site where you can review SQR Workbench bugs/fixes
> > (we
> > are licensed for SQR thru PeopleSoft) and SQR Messages/Codes?
> >
> > Thanks!
> > Linda
> >
> > ___________
> > Linda Krey
> > PeopleSoft Application Specialist
> > Office of Information Technology
> >
> > American Heart Association
> > 7272 Greenville Avenue
> > Dallas, TX  75231-4596
> > 214.706.1459 (Voice Mail 1459)
> > 214.706.1211 FAX

--------------------------------------------------------------------------------------------------------------------------------
Benjamin Le
ITS, System Development
Portland Community College
12000 SW 49th Ave. Portland, Oregon 97219
(503)-977-4970  Fax: (503)-977-4987
Mailto:ble@pcc.edu      http://www.pcc.edu
--------------------------------------------------------------------------------------------------------------------------------