Date

[WannaLearn]

Is there anything wrong with this bit of code? I always get an error when someone tries to pass the date as 2/29/2005 or 2/30/2005.

<cfif myYear neq "" and myMonth neq "" and myDay neq "">
<cfset myDOB = myYear & "/" & myMonth & "/" & myDay>
<cfif not listfind("4,6,9,11",myMonth) and myDay neq "31">
<cfset myDOB = DateFormat(myDOB, "yy/mm/dd")>
<cfelseif not listfind("29,30,31",myDay) and myMonth neq "2">
<cfset myDOB = DateFormat(myDOB, "yy/mm/dd")>
<cfelse>
<cfset myDOB = "">
</cfif>
<cfelse>
<cfset myDOB = "">
</cfif>


Thanks.

 

[webmigit]

February 29 is only valid on leap years and February 30 is never valid... Try this code..

<cfif isNumeric(myYear) neq "" and isNumeric(myMonth) neq "" and isNumeric(myDay) neq "">
  <cfset firstday = myMonth & "/1/" & myYear>
  <cfif daysinmonth(mymonth) lt myDay>
  <cfset myDOB = myMonth & "/" & myDay & "/" & myYear>
    <cfif not listfind("4,6,9,11",myMonth) and myDay neq "31">
      <cfset myDOB = DateFormat(myDOB, "yy/mm/dd")>
    <cfelseif not listfind("29,30,31",myDay) and myMonth neq "2">
      <cfset myDOB = DateFormat(myDOB, "yy/mm/dd")>
    <cfelse>
      <cfset myDOB = "">
    </cfif>
  <cfelse>
    <!--- the day specified is greater than the number of days in the specified month --->
    <cfset myDOB = "">
  </cfif>
<cfelse>
  <cfset myDOB = "">
</cfif>

In reality though, this should work as well..

<cfif isNumeric(myYear) neq "" and isNumeric(myMonth) neq "" and isNumeric(myDay) neq "">
  <cfset firstday = myMonth & "/1/" & myYear>
  <cfif daysinmonth(mymonth) lt myDay>
    <cfset myDOB = myMonth & "/" & myDay & "/" & myYear>
    <cfset myDOB = DateFormat(myDOB, "yy/mm/dd")>
  <cfelse>
    <!--- the day specified is greater than the number of days in the specified month --->
    <cfset myDOB = "">
  </cfif>
<cfelse>
  <cfset myDOB = "">
</cfif>

http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi65.htm

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.