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