StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PODate Calculation Discrepency (JavaScript VS .NET)
text
Body
copied!<p>I'm trying to calculate the "timeago" and I'm coming up with a descrepancy in my code.</p> <p>Using Today's Date</p> <blockquote> <p>November 7, 2010</p> </blockquote> <p>If I use <strong>September 1, 2010</strong> then both my .NET code and my JS code say "2 months"</p> <p>If I use <strong>August 31, 2010</strong> then my .NET code says "3 months" and my JS code says at "2 months"</p> <p>This discrepancy stays until <strong>August 9, 2010</strong>.</p> <p>Basically the dateDiff is "off" from August 10 - August 31 based on todays date of November 7.</p> <p>Here's the JavaScript (taken from "<a href="https://github.com/rmm5t/jquery-timeago" rel="nofollow">timeago</a>" plugin)</p> <pre><code> var words = seconds < 45 && substitute($l.seconds, Math.round(seconds)) || seconds < 90 && substitute($l.minute, 1) || minutes < 45 && substitute($l.minutes, Math.round(minutes)) || minutes < 90 && substitute($l.hour, 1) || hours < 24 && substitute($l.hours, Math.round(hours)) || hours < 48 && substitute($l.day, 1) || days < 30 && substitute($l.days, Math.floor(days)) || days < 60 && substitute($l.month, 1) || days < 365 && substitute($l.months, Math.floor(days / 30)) || years < 2 && substitute($l.year, 1) || substitute($l.years, Math.floor(years)); </code></pre> <p>And here's my .NET code (written by me)</p> <pre><code> Public Function ToDuration(ByVal dt As Date?, _ Optional ByVal suffixAgo As String = Nothing) As String If Not dt Is Nothing Then Dim theDate As Date = dt Dim SecondsAppart As Integer = DateDiff(DateInterval.Second, theDate, Now) Dim output As String If SecondsAppart < 86400 Then Select Case SecondsAppart Case Is <= 59 : output = "less than a minute " & suffixAgo Case Is <= 119 : output = "about a minute " & suffixAgo Case Is <= 3599 : output = DateDiff(DateInterval.Minute, theDate, Now) & " minutes " & suffixAgo Case Is <= 7199 : output = "about an hour " & suffixAgo Case Else : output = DateDiff(DateInterval.Hour, theDate, Now) & " hours " & suffixAgo End Select Else Dim DaysAppart As Integer = DateDiff(DateInterval.Day, theDate, Now) Select Case DaysAppart Case Is <= 1 : output = "yesterday" Case Is <= 30 : output = DateDiff(DateInterval.Day, theDate, Now) & " days " & suffixAgo Case Is <= 60 : output = "about a month " & suffixAgo Case Is <= 365 : output = DateDiff(DateInterval.Month, theDate, Now) & " months " & suffixAgo Case Is <= 730 : output = "about a year " & suffixAgo Case Else : output = DateDiff(DateInterval.Year, theDate, Now) & " years " & suffixAgo End Select End If Return output Else Return String.Empty End If End Function </code></pre> <p>So the problem I'm having is a fundamental one as well as a logistic one.</p> <ol> <li>Which code is "right" when it comes to DateDiff? (<em>IE: Is 2 months and 14 days considered 2 months or 3?</em>)</li> <li>What is the best way to get them to line up accordingly?</li> </ol>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload