Re: Date question

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 53292
interpreted = N
texte = Your leap year calculation isn't right. I'm not familiar with the 11 missing days for the Gregorian Reformation so those are not be part of the calculation. Frankly, I've never seen a date calculator (common one) that had the 11 days whacked (I might be wrong, it's been a long time since I did this). Here's how it works: 2003 x 365 - base days up to 2003 + 280 days - days from jan 1 + floor(2003/4) - leap days since start (partial calc) - floor(2003/100) - subtract leap day at century markers (partial calc) + floor(2003/400) - add leap day at century if multiple of 400 >Hi! > >I'm trying to implement an timestamp function and have a question. What does the numerical result of [math]{[date]}[/math] represent? On my US Mac with a date of 10/07/2003, I get 731860. This is almost the number of days since year 01/01/0000, but not quite.... > >Regular Year: 731860/365=2005.096 >Including Leap Years: 731860/365.25=2003.723 >Including Leap Years and 11 days missing due to the Gregorian Reformation (731860+11)/365.25=203.754 > >Oct. 7, 2003 is the 280th day of the year: 280/365.25=0.7665982 > >Thanks, > >Andy > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://webdna.smithmicro.com/ -- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Quick Date Question (Govinda 2008)
  2. Re: [WebDNA] Quick Date Question (Govinda 2008)
  3. Re: [WebDNA] Quick Date Question (Steve Craig 2008)
  4. Re: [WebDNA] Quick Date Question (Gil Poulsen 2008)
  5. [WebDNA] Quick Date Question (Steve Craig 2008)
  6. Re: Silly date question ( Donovan Brooke 2006)
  7. Re: Silly date question ( Donovan Brooke 2006)
  8. Re: Silly date question ( Steve Craig 2006)
  9. Re: Silly date question ( Steve Craig 2006)
  10. Re: Silly date question ( Donovan Brooke 2006)
  11. Re: Silly date question ( Gary Krockover 2006)
  12. Re: Silly date question ( Donovan Brooke 2006)
  13. Silly date question ( Steve Craig 2006)
  14. Re: Date question ( Donovan Brooke 2003)
  15. Re: Date question ( John Peacock 2003)
  16. Re: Date question ( Donovan Brooke 2003)
  17. Re: Date question ( Donovan Brooke 2003)
  18. Re: Date question ( Alex McCombie 2003)
  19. Re: Date question ( andy mowrey 2003)
  20. Re: Date question ( John Hill 2003)
  21. Date question ( andy mowrey 2003)
  22. Re: Date Question (Dan Strong 2002)
  23. Re: Date Question (Gary Krockover 2002)
  24. Re: Date Question (Dan Strong 2002)
  25. Re: Date Question (Kenneth Grome 2002)
  26. Re: Date Question (Jeff Logan 2002)
  27. Re: Date Question (Donovan 2002)
  28. Re: Date Question (Donovan 2002)
  29. Re: Date Question (Jeff Logan 2002)
  30. Re: Date Question (Chris List Recipient 2002)
  31. Re: Date Question (Jeff Logan 2002)
  32. Re: Date Question (Dan Strong 2002)
  33. Re: Date Question (Jeff Logan 2002)
  34. Re: Date Question (Gary Krockover 2002)
  35. Re: Date Question (Jeff Logan 2002)
  36. Re: Date Question (John Peacock 2002)
  37. Re: Date Question (Dan Strong 2002)
  38. Re: Date Question (Jeff Logan 2002)
  39. Re: Date Question (Dan Strong 2002)
Your leap year calculation isn't right. I'm not familiar with the 11 missing days for the Gregorian Reformation so those are not be part of the calculation. Frankly, I've never seen a date calculator (common one) that had the 11 days whacked (I might be wrong, it's been a long time since I did this). Here's how it works: 2003 x 365 - base days up to 2003 + 280 days - days from jan 1 + floor(2003/4) - leap days since start (partial calc) - floor(2003/100) - subtract leap day at century markers (partial calc) + floor(2003/400) - add leap day at century if multiple of 400 >Hi! > >I'm trying to implement an timestamp function and have a question. What does the numerical result of [math]{[date]}[/math] represent? On my US Mac with a date of 10/07/2003, I get 731860. This is almost the number of days since year 01/01/0000, but not quite.... > >Regular Year: 731860/365=2005.096 >Including Leap Years: 731860/365.25=2003.723 >Including Leap Years and 11 days missing due to the Gregorian Reformation (731860+11)/365.25=203.754 > >Oct. 7, 2003 is the 280th day of the year: 280/365.25=0.7665982 > >Thanks, > >Andy > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://webdna.smithmicro.com/ -- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ John Hill

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Multiple adding (1997) E-mail loop ! (1997) [ot] Authorize.Net Resellers (2006) Reversed words (1997) Appending Information from one db to another (1998) unable to launch acgi in WebCat (1997) no serial? (1998) all db's in one folder and protected (1998) More than one db with the same namn (was: WC2f3) (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) CAPTCHA (2006) RAM variables (1997) Which GUI HTML editors work with WC ? (1997) PROBLEMS WITH PROTECT TAG (2004) [Reload mydata.db] (1998) Include files (1998) RE: Search (1997) Upgrading old WebCat Database Files (1997) redirect not passing vars (2004) SKU lookup (1997)