Ask a Question related to Coldfusion - Getting Started, Design and Development.

  1. #1

    Default 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 negative number. Is
    there any way that I can change the datediff below to produce a positive number
    instead of a negative number? Thank you.

    <cfif datediff('d',now(),getUserInfo.PWchangeDate) gte 90>
    <cflocation URL="#Request.Self#?fuseAction=changePassword&msg= 5" addtoken="No">
    </cfif>

    Winston2 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. 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 Command Help
      Hi, can someone please help me solve the following problem. This datedifference command boggles me. I have a recorded date/time and I want to...
  3. #2

    Default Re: dateDiff Question

    <cfif ABS(datediff('d',now(),getUserInfo.PWchangeDate)) gte 90>


    BKBK Guest

  4. #3

    Default Re: dateDiff Question

    Thank you very much guys.
    I really appreciate your help.
    Winston2 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