Re: year/month comparisons from date fields

["Peter Dow" <maillist@xxxxxxxxxxxxxxx>]

Hi Grizzly,

You didn't mention what release you're working with and you weren't explicit
as to what kind of comparison, so here are a couple of examples of the
%SUBDT bif:

/free
if %subdt(date1:*years) = %subdt(date2:*years) and
   %subdt(date1:*months) = %subdt(date2:*months);
...
endif;
/end-free

or

/free
if %subdt(date1:*years) * 100 + %subdt(date1:*months) >
   %subdt(date2:*years) * 100 + %subdt(date2:*months);
...
endif;
/end-free

There's also the EXTRCT op code.

hth,
Peter Dow
Dow Software Services, Inc.
909 793-9050 voice
909 522-3214 cellular
909 793-4480 fax

----- Original Message -----
From: "Malchow, Grizzly"
Sent: Friday, April 11, 2003 12:16 PM


I'm trying to compare the month and year values of 2 different date
fields. Does anyone know this is done?