DateDiff Problem with the Year 2000

Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.

  1. #1

    Default DateDiff Problem with the Year 2000

    I am having a problem calculating the proper age of people if they were born in
    the year 2000

    <cfset bydate=#dateformat(#todaydate#,"mm/dd/yy")#>
    <cfset year="#datediff("yyyy",form.bday,bydate)#">

    I enter my daughters bday 2/16/2000 and it returns her age as 4 instead of 5.
    Same with anyone else born in the year 2000.

    Has anyone else had this problem. Is there a fix? Is it my code?

    Thanks

    Sharon

    Smiller Guest

  2. Similar Questions and Discussions

    1. Datediff() bug
      The Datediff("m",startdate,enddate) function does not return the correct value if the startdate is "2/28/05" and the enddate has a day value of...
    2. Datediff Problem
      I am having some difficulties with the function Datediff! I am trying to calculate the number of days between two given date E.G: Number days...
    3. Query - Datediff problem
      Hello all, I am trying to generate a list of users that have not responded to a survey in 3 months, but I am running into problems with the...
    4. Datediff
      Hello Newsgroup, I have a little problem. I want to know the difference between two dates but I need this in a german format. First Date :...
    5. DateDiff problem on different servers
      I have an ASP page that lists files and folders in a directory. I'm using a cookie to record the last time this page was visited, and I intend to...
  3. #2

    Default Re: DateDiff Problem with the Year 2000

    if you're using mx, make sure you have the [url]http://www.macromedia.com/support/documentation/en/coldfusion/mx61updater/releasenotes_cfmx61_updater02.html[/url] installed.

    PaulH Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139