Skip to main content

Andrew

Member since Apr 9, 2010

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 »

I believe in love. I believe in compassion. I believe in human rights. I believe that we can afford to give more of these gifts to the world around us because it costs us nothing to be decent and kind and understanding. And, I want you to know that when you land on this site, you are accepted for who you are, no matter how you identify, what truths you live, or whatever kind of goofy shit makes you feel alive! Rock on with your bad self!
Ben Nadel