Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
IN BETWEEN QUERY
- Thread starter kingjjx
- Start date
DateCompare will perform a full date/time comparison of two dates. Returns -1 if date1 is less than date2; returns 0 if date1 is equal to date2; returns 1 if date1 is greater than date2;
save this example as a test.cfm and analize it:
<HTML>
<HEAD>
<TITLE>
DateCompare Example
</TITLE>
</HEAD>
<basefont face="Arial, Helvetica" size=2>
<H3>DateCompare Example</H3>
<P>The datecompare function compares two date/time values.
<CFIF IsDefined("FORM.date1"
>
<CFIF IsDate(FORM.date1) and IsDate(FORM.date2)>
<CFSET comparison = DateCompare(FORM.date1, FORM.date2, FORM.precision)>
<!--- switch on the variable to give various responses --->
<CFSWITCH EXPRESSION=#comparison#>
<CFCASE VALUE="-1">
<H3><CFOUTPUT>#DateFormat(FORM.date1)#
#TimeFormat(FORM.date1)#</CFOUTPUT> (Date 1) is
earlier than <CFOUTPUT>#DateFormat(FORM.date2)#
#TimeFormat(FORM.date2)#</CFOUTPUT> (Date 2)</H3>
<I>The dates are not equal</I>
</CFCASE>
<CFCASE VALUE="0">
<H3><CFOUTPUT>#DateFormat(FORM.date1)#
#TimeFormat(FORM.date1)#</CFOUTPUT> (Date 1) is equal
to <CFOUTPUT>#DateFormat(FORM.date2)#
#TimeFormat(FORM.date2)#</CFOUTPUT> (Date 2)</H3>
<I>The dates are equal!</I>
</CFCASE>
<CFCASE VALUE="1">
<H3><CFOUTPUT>#DateFormat(FORM.date1)#
#TimeFormat(FORM.date1)#</CFOUTPUT> (Date 1) is later
than <CFOUTPUT>#DateFormat(FORM.date2)#
#TimeFormat(FORM.date2)#</CFOUTPUT> (Date 2)</H3>
<I>The dates are not equal</I>
</CFCASE>
<CFDEFAULTCASE>
<H3>This is the default case</H3>
</CFDEFAULTCASE>
</CFSWITCH>
<CFELSE>
<H3>Please enter two valid date values</H3>
</CFIF>
</CFIF>
<FORM ACTION="test.cfm" METHOD="POST">
<hr size="2" color="#0000A0">
<P>Date 1
<BR><INPUT TYPE="Text" NAME="date1" VALUE="<CFOUTPUT>#DateFormat(Now())#
#TimeFormat(Now())#
</CFOUTPUT>">
<P>Date 2
<BR><INPUT TYPE="Text" NAME="date2" VALUE="<CFOUTPUT>#DateFormat(Now())#
#TimeFormat(Now())#
</CFOUTPUT>">
<P>Specify precision to the:
<BR><select NAME="precision">
<option VALUE="s">
Second
</OPTION>
<option VALUE="n">
Minute
</OPTION>
<option VALUE="h">
Hour
</OPTION>
<option VALUE="d">
Day
</OPTION>
<option VALUE="m">
Month
</OPTION>
<option VALUE="yyyy">
Year
</OPTION>
</select>
<P><INPUT TYPE="Submit" VALUE="Compare these dates" NAME="">
<INPUT TYPE="RESET">
</FORM>
</BODY>
</HTML> Sylvano
dsylvano@hotmail.com
save this example as a test.cfm and analize it:
<HTML>
<HEAD>
<TITLE>
DateCompare Example
</TITLE>
</HEAD>
<basefont face="Arial, Helvetica" size=2>
<H3>DateCompare Example</H3>
<P>The datecompare function compares two date/time values.
<CFIF IsDefined("FORM.date1"
><CFIF IsDate(FORM.date1) and IsDate(FORM.date2)>
<CFSET comparison = DateCompare(FORM.date1, FORM.date2, FORM.precision)>
<!--- switch on the variable to give various responses --->
<CFSWITCH EXPRESSION=#comparison#>
<CFCASE VALUE="-1">
<H3><CFOUTPUT>#DateFormat(FORM.date1)#
#TimeFormat(FORM.date1)#</CFOUTPUT> (Date 1) is
earlier than <CFOUTPUT>#DateFormat(FORM.date2)#
#TimeFormat(FORM.date2)#</CFOUTPUT> (Date 2)</H3>
<I>The dates are not equal</I>
</CFCASE>
<CFCASE VALUE="0">
<H3><CFOUTPUT>#DateFormat(FORM.date1)#
#TimeFormat(FORM.date1)#</CFOUTPUT> (Date 1) is equal
to <CFOUTPUT>#DateFormat(FORM.date2)#
#TimeFormat(FORM.date2)#</CFOUTPUT> (Date 2)</H3>
<I>The dates are equal!</I>
</CFCASE>
<CFCASE VALUE="1">
<H3><CFOUTPUT>#DateFormat(FORM.date1)#
#TimeFormat(FORM.date1)#</CFOUTPUT> (Date 1) is later
than <CFOUTPUT>#DateFormat(FORM.date2)#
#TimeFormat(FORM.date2)#</CFOUTPUT> (Date 2)</H3>
<I>The dates are not equal</I>
</CFCASE>
<CFDEFAULTCASE>
<H3>This is the default case</H3>
</CFDEFAULTCASE>
</CFSWITCH>
<CFELSE>
<H3>Please enter two valid date values</H3>
</CFIF>
</CFIF>
<FORM ACTION="test.cfm" METHOD="POST">
<hr size="2" color="#0000A0">
<P>Date 1
<BR><INPUT TYPE="Text" NAME="date1" VALUE="<CFOUTPUT>#DateFormat(Now())#
#TimeFormat(Now())#
</CFOUTPUT>">
<P>Date 2
<BR><INPUT TYPE="Text" NAME="date2" VALUE="<CFOUTPUT>#DateFormat(Now())#
#TimeFormat(Now())#
</CFOUTPUT>">
<P>Specify precision to the:
<BR><select NAME="precision">
<option VALUE="s">
Second
</OPTION>
<option VALUE="n">
Minute
</OPTION>
<option VALUE="h">
Hour
</OPTION>
<option VALUE="d">
Day
</OPTION>
<option VALUE="m">
Month
</OPTION>
<option VALUE="yyyy">
Year
</OPTION>
</select>
<P><INPUT TYPE="Submit" VALUE="Compare these dates" NAME="">
<INPUT TYPE="RESET">
</FORM>
</BODY>
</HTML> Sylvano
dsylvano@hotmail.com
- Status
Similar threads
