Re: Date Comparison in Oracle

[Albert Howard <starbukk@concentric.net>]

If this is for PeopleSoft, use FORMAT-DATETIME and convert each date to
DATECMP format first.

FORMAT-DATETIME($date1,$date1cmp,{DEFCMP},'','')

Then compare these results.
Good luck!

At 10:57 AM 9/24/98 -0400, you wrote:
>I need to select the earlier of several dates within an SQR.
>I've tried various date formats and using
>
>  if $Date1 < Date2
>        let $Date3 = Date2
>  end-if
>
>I don't get date errors but the program simply replaces each date whether it
>is earlier or not.  Is there a special format required for this syntax or is
>there a different way to compare dates?   Thanks All.
>
>SHope
>