Andrew
Member since Apr 9, 2010
- Profile: /members/5801-andrew.htm
- Comments: 3
Recent Blog Comments By Andrew
-
Ask Ben: Displaying And Formatting The Difference Between Two Dates
Posted on Oct 7, 2011 at 12:23 PM
Please see my rather convoluted explanation above on why it doesn't work for months and years :) This method only works for: day (using fix), hours, mins, secs. It's borked for months, years. Basically it shifting everything (taking the difference) to 30/12/1899 as the zero-point, which is why the ... read more »
-
Ask Ben: Displaying And Formatting The Difference Between Two Dates
Posted on Apr 9, 2010 at 9:41 AM
Hi Ben, Sorry I was a bit garbled when I said that, and the example I gave are a bit of a redundancy! As long as we use your method to figure out the difference in days, hours, mins and seconds -- it still works perfectly under all circumstances. So your example works, since you are working with d... read more »
-
Ask Ben: Displaying And Formatting The Difference Between Two Dates
Posted on Apr 9, 2010 at 4:13 AM
Hi Ben, I was trying out your code and getting the wrong results. Then I realise your code (I think) doesn't really work... CF represents datetime as a real no where the integer part represents the no of days before/after a point 0 = 12/30/1899, the fractional part is the time. So taking a differe... read more »