August 2001
Intermediate to advanced
976 pages
38h 8m
English
DateCompare
DateCompare(date1, date2[,datepart])
Compares two date/time objects. Returns -1 if
date1 is less than
date2, 0 if both date/time objects are
equal, or 1 if date1 is greater than
date2. The comparison may be limited to a
specific part of the date/time object by specifying a value for the
optional datepart parameter. Valid
attributes for datepart are:
s (second), n (minute),
h (hour), d (day),
m (month), and yyyy (year).
Examples:
<CFOUTPUT>
Compare 08/15/99 and 08/15/99: #DateCompare('08/15/99', '08/15/99')#<BR>
Compare 08/15/99 and 08/15/1999: #DateCompare('08/15/99', '08/15/1999')#<BR>
Compare 15 Aug 1998 and 8/15/98: #DateCompare('15 Aug 1998', '8/15/98')#<BR>
Compare August 15, 1998 and July 4, 1997:
#DateCompare('August 15, 1998', 'July 4, 1997')#<BR>
Compare 19:00:00 and 7pm: #DateCompare('19:00:00', '7pm')#<BR>
Compare 6:00 and 7:00: #DateCompare('6:00', '7:00')#<BR>
Compare 8/15/1998 and Jan 3, 1999 by year:
#DateCompare('8/15/1998', 'Jan 3, 1999', 'yyyy')#<BR>
Compare 6:59 and 7:38 by minute: #DateCompare('6:59', '7:38', 'n')#
</CFOUTPUT>Read now
Unlock full access