Understanding the DateDiff function
Does anyone know why the code below would return 5 or 6 for its value when LastContacted is 10/21/2009. I only want it to return 5 because there are 5 days in between today and that date.
Any direction you can provide would be appreciated.
Any direction you can provide would be appreciated.
<cfset displaydate = dateDiff('d', LastContactDate, Now()) + 1 />
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
check the timestamp in the server. Sine Now() function return the current date from coldfusion server, the resule might have changed due to difference between server timestamp and your system timestamp.
ASKER