Re: Julian Day/Date Formatting

[Linda Krey <linda.krey@HEART.ORG>]

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