home *** CD-ROM | disk | FTP | other *** search
/ Chip 2002 February / CHIPCD_02_2002.iso / Internet / Macromedia ColdFusion Server 5 / coldfusion-50-win-us.exe / data1.cab / Examples / CFDOCS / snippets / datediff.cfm < prev    next >
Encoding:
Text File  |  2001-06-13  |  2.7 KB  |  99 lines
  1. <!--- This example shows the use of DateDiff --->
  2.  
  3. <HTML>
  4.  
  5. <HEAD>
  6. <TITLE>
  7. DateDiff Example
  8. </TITLE>
  9. </HEAD>
  10.  
  11. <BASEFONT FACE="Arial, Helvetica" SIZE=2>
  12. <BODY  bgcolor="#FFFFD5">
  13.  
  14. <H3>DateDiff Example</H3>
  15.  
  16. <CFPARAM name="value" default="3">
  17. <CFPARAM name="type" default="yyyy">
  18.  
  19. <!--- if numbers passed, then use those --->
  20. <CFIF IsDefined("form.value")>
  21.     <CFSET value = form.value>
  22. </CFIF>
  23. <CFIF IsDefined("form.type")>
  24.     <CFSET type = form.type>
  25. </CFIF>
  26.  
  27. <CFIF IsDefined("form.date1") and IsDefined("form.date2")>
  28.  
  29.     <CFIF IsDate(form.date1) and IsDate(form.date2)>
  30.     
  31.         <P>This example uses DateDiff to determine the difference
  32.         in     <CFSWITCH EXPRESSION=#type#>
  33.             <CFCASE VALUE="yyyy">years</CFCASE>
  34.             <CFCASE VALUE="q">quarters</CFCASE>
  35.             <CFCASE VALUE="m">months</CFCASE>
  36.             <CFCASE VALUE="y">days of year</CFCASE>    
  37.             <CFCASE VALUE="d">days</CFCASE>    
  38.             <CFCASE VALUE="w">weekdays</CFCASE>    
  39.             <CFCASE VALUE="ww">weeks</CFCASE>    
  40.             <CFCASE VALUE="h">hours</CFCASE>    
  41.             <CFCASE VALUE="n">minutes</CFCASE>    
  42.             <CFCASE VALUE="s">seconds</CFCASE>        
  43.             <CFDEFAULTCASE>years</CFDEFAULTCASE></CFSWITCH>
  44.              dateparts between date1 and date2.
  45.         
  46.         <CFIF DateCompare("#form.date1#","#form.date2#") is not 0>
  47.         <P>The difference is <CFOUTPUT>#Abs(DateDiff(type, form.date2, form.date1))#</CFOUTPUT>
  48.         <CFSWITCH EXPRESSION=#type#>
  49.             <CFCASE VALUE="yyyy">years</CFCASE>
  50.             <CFCASE VALUE="q">quarters</CFCASE>
  51.             <CFCASE VALUE="m">months</CFCASE>
  52.             <CFCASE VALUE="y">days of year</CFCASE>    
  53.             <CFCASE VALUE="d">days</CFCASE>    
  54.             <CFCASE VALUE="w">weekdays</CFCASE>    
  55.             <CFCASE VALUE="ww">weeks</CFCASE>    
  56.             <CFCASE VALUE="h">hours</CFCASE>    
  57.             <CFCASE VALUE="n">minutes</CFCASE>    
  58.             <CFCASE VALUE="s">seconds</CFCASE>        
  59.             <CFDEFAULTCASE>years</CFDEFAULTCASE></CFSWITCH>.
  60.         <CFELSE>
  61.         <P>The two dates are equal!  Try changing one of the values ...
  62.         </CFIF>
  63.     
  64.     <CFELSE>
  65.     <P>Please enter two valid date/time values, formatted like this:
  66.     <CFOUTPUT>#DateFormat(Now())#</CFOUTPUT>    
  67.     </CFIF>    
  68.  
  69. </CFIF>
  70. <FORM action="datediff.cfm" METHOD="post">
  71.  
  72. <PRE>
  73. Date 1
  74. <INPUT TYPE="Text" NAME="date1" VALUE="<CFOUTPUT>#DateFormat(Now())#</CFOUTPUT>">
  75. Date 2
  76. <INPUT TYPE="Text" NAME="date2" VALUE="<CFOUTPUT>#DateFormat(Now())#</CFOUTPUT>">
  77. What kind of unit to show difference?
  78.     <SELECT NAME="type">
  79.         <OPTION value="yyyy" SELECTED>years
  80.         <OPTION value="q" >quarter
  81.         <OPTION value="m" >month
  82.         <OPTION value="y" >day of year
  83.         <OPTION value="d" >day
  84.         <OPTION value="w" >weekday
  85.         <OPTION value="ww" >week                        
  86.         <OPTION value="h" >hour
  87.         <OPTION value="n" >minute
  88.         <OPTION value="s" >second
  89.         </SELECT>
  90. </PRE>
  91.  
  92. <INPUT TYPE="Submit" NAME=""><INPUT TYPE="RESET">
  93. </FORM>
  94.  
  95.  
  96. </BODY>
  97.  
  98. </HTML>       
  99.