Re: Julian Day/Date Formatting

[Peter Clark <PGCLARK@VAC-ACC.GC.CA>]

Ben,

PeopleSoft users of SQR are pretty well locked into whatever version of SQR 
that PeopleSoft supports for any given version of PeopleSoft. This is done to 
ensure that the suite of PeopleSoft reports delivered will work as advertised.

Peter

>>> Ben Le <ble@PCC.EDU> 2001/05/14 1:16:07 pm >>>
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
--------------------------------------------------------------------------------------------------------------------------------