Ask a Question related to Macromedia ColdFusion, Design and Development.

  1. #21

    Default Re: Datediff() bug

    You're right, Larry. There has to be something wrong with results like this:

    DateDiff("m","2/28/04","3/28/04") = 1
    DateDiff("m","2/29/04","3/29/04") = 0

    You're probably better off rolling your own.

    Iceborer Guest

  2. Similar Questions and Discussions

    1. dateDiff Question
      During login I'm testing whether the user has changed their password in the last 90 days. Unfortunately the dateDiff function I'm using produces a...
    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. 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 :...
    4. DateDiff in C#
      Hello, I am attempting to port some VB.NET code to C#.NET and have run across the DateDiff function in VB.NET. Does anyone know what the...
    5. DateDiff and Format
      Hello, I've included a datediff function in my stored procedure, and it works correctly, but I want to format it to return only the Month and...
  3. #22

    Default Datediff() bug

    0 years 0 mons 0 days 0 hours -15 mins -50.00 secs. can i converte this into HH:MM:SS..hope so much.
    shazzuan is offline Junior Member
    Join Date
    Nov 2011
    Location
    kuala lumpur,malaysia
    Posts
    1

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