New Posts For Thread: Date format and Computer Timeform Helphttps://community.betfair.com/general_betting/go/thread/view/94082/23494974/date-format-and-computer-timeform-helpHi I posted this on the Horse racing forum and it was suggested I may get a better response on here. Fingers crossedHi within the Computer Timeform Table the dates are expressed as numbers for example 1060527 = 27/05/2006 CAn anyone give me a steer aWoooo yes yes yes cheers matehttps://community.betfair.com/general_betting/go/thread/view/94082/23494974/date-format-and-computer-timeform-help?post_id=419717002#419717002Woooo yes yes yes cheers mateFri, 22 Jan 2010 15:31:04 -0600this one Grey imo :-)https://community.betfair.com/general_betting/go/thread/view/94082/23494974/date-format-and-computer-timeform-help?post_id=419716990#419716990this one Grey imo :-)Fri, 22 Jan 2010 15:29:56 -0600Thanks ILBM. What would you do though if you were inputting dates of artefacts then?https://community.betfair.com/general_betting/go/thread/view/94082/23494974/date-format-and-computer-timeform-help?post_id=419716910#419716910Thanks ILBM. What would you do though if you were inputting dates of artefacts then?Sun, 23 Mar 2008 09:09:42 -0500Feck, excel's date function checks the parameter passed in for the year. If it's between 0 and 1899 it adds 1900 to it on your behalf before using it to format the date.So 0 = 1900, 1899=3799. I doubt if anyone will be using the ssheet in the yearhttps://community.betfair.com/general_betting/go/thread/view/94082/23494974/date-format-and-computer-timeform-help?post_id=419716906#419716906Feck, excel's date function checks the parameter passed in for the year. If it's between 0 and 1899 it adds 1900 to it on your behalf before using it to format the date.So 0 = 1900, 1899=3799. I doubt if anyone will be using the ssheet in the yearSun, 23 Mar 2008 08:49:34 -0500I think ILBM was more deserving of your thanks ILBM.ILBM, I was thinking if the tf date was 1550101 would excel not assume that the year was 155 unless the 1900 was added? If not, how would you create such a date?https://community.betfair.com/general_betting/go/thread/view/94082/23494974/date-format-and-computer-timeform-help?post_id=419716902#419716902I think ILBM was more deserving of your thanks ILBM.ILBM, I was thinking if the tf date was 1550101 would excel not assume that the year was 155 unless the 1900 was added? If not, how would you create such a date?Sun, 23 Mar 2008 08:06:40 -0500Thanks a lot everyone much appreciatedhttps://community.betfair.com/general_betting/go/thread/view/94082/23494974/date-format-and-computer-timeform-help?post_id=419716898#419716898Thanks a lot everyone much appreciatedSun, 23 Mar 2008 07:58:59 -0500Cheers Feck, I think im there .Let me know if you need any Tables from this year ;O)https://community.betfair.com/general_betting/go/thread/view/94082/23494974/date-format-and-computer-timeform-help?post_id=419716894#419716894Cheers Feck, I think im there .Let me know if you need any Tables from this year ;O)Sun, 23 Mar 2008 07:57:13 -0500excel will add 1900 automatically to the year parameter you pass to the date() function if it's between 0 and 1899 - so 106 becomes 2006 anyway.TBH, it doesn't matter. if you pass a value 2000, it doesn't add 1900 so it won't make any difference.https://community.betfair.com/general_betting/go/thread/view/94082/23494974/date-format-and-computer-timeform-help?post_id=419716890#419716890excel will add 1900 automatically to the year parameter you pass to the date() function if it's between 0 and 1899 - so 106 becomes 2006 anyway.TBH, it doesn't matter. if you pass a value 2000, it doesn't add 1900 so it won't make any difference.Sun, 23 Mar 2008 07:56:38 -0500How do you mean ILBM? You want it to add 1900. e.g. in the example Grey Shot gave the year would be TRUNC(106527/10000)+1900 = 2006.https://community.betfair.com/general_betting/go/thread/view/94082/23494974/date-format-and-computer-timeform-help?post_id=419716886#419716886How do you mean ILBM? You want it to add 1900. e.g. in the example Grey Shot gave the year would be TRUNC(106527/10000)+1900 = 2006.Sun, 23 Mar 2008 07:53:04 -0500be careful adding 1900... I belive excel adds tha 1900???https://community.betfair.com/general_betting/go/thread/view/94082/23494974/date-format-and-computer-timeform-help?post_id=419716882#419716882be careful adding 1900... I belive excel adds tha 1900???Sun, 23 Mar 2008 07:49:23 -0500