Forget that , thanks Hendrik! -------------------------------------------- Freeserve Production: Turning Ideas Into Reality
Russell Brown Internet Application Developer Freeserve.com Plc, PO Box 452, Leeds LS2 7EY Never pay another Internet phone bill! Freeserve AnyTime, for all the Internet access you want, day and night, only 12.99 per month. Sign-up at http://www.freeserve.com/time/anytime -----Original Message----- From: Russell Brown [mailto:[EMAIL PROTECTED]] Sent: 19 February 2002 16:41 To: Spectra-Talk Subject: RE: Date Time in Spectra Thanks Spike, It explains a lot . But how do I turn a normal date Time like {ts '2002-02-19 16:40:11'} into a a 37237.487905100 type (or do I just count the days ?) Thanks again Regards Russell -------------------------------------------- Freeserve Production: Turning Ideas Into Reality Russell Brown Internet Application Developer Freeserve.com Plc, PO Box 452, Leeds LS2 7EY Never pay another Internet phone bill! Freeserve AnyTime, for all the Internet access you want, day and night, only 12.99 per month. Sign-up at http://www.freeserve.com/time/anytime -----Original Message----- From: Spike [mailto:[EMAIL PROTECTED]] Sent: 19 February 2002 16:31 To: Spectra-Talk Subject: RE: Date Time in Spectra They are the time in days since 1900. You can convert them to a date as follows: dateadd('d',0,thisdate) Spike -----Original Message----- From: Russell Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 3:08 PM To: Spectra-Talk Subject: Date Time in Spectra Hi, When querying the codb all dates come back as 37237.656307900 type strings. I can turn these into regular date time objects with DateConvert("utc2local",37237.656307900) but cannot turn a normal date object to 37237.656307900 type date with DateConvert("local2utc",now()). Any idea what sort of dates these 37237.656307900 type dates are, and how best to work with them ? Are they Roman, Gregorian, Julien or wtf are they ? Any CF functions for working with these dates (particularily turning Now() into a 37237.656307900 type date, would be very very cool) Thanks in Advance Russell -------------------------------------------- Freeserve Production: Turning Ideas Into Reality Russell Brown Internet Application Developer Freeserve.com Plc, PO Box 452, Leeds LS2 7EY Never pay another Internet phone bill! Freeserve AnyTime, for all the Internet access you want, day and night, only 12.99 per month. Sign-up at http://www.freeserve.com/time/anytime ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
