On 3/3/2010 6:35 PM, I. Addoum. wrote: > > @Paul > > come again ?! > > Datediff should be dropped , > and a custom function that takes two cf date objects > converts them to numeric values and do the math ( subtract and return result > in desired form )
> how does that not solve the problem ? because it doesn't. you simply threw out that problem along w/the time data (and a level of accuracy). if you want to remove tz, etc. from this & keep accuracy use epoch offsets: aJavaEpochOffset=yourCFDateObject.getTime(); // ms since java epoch downside is dealing w/BIG numbers (or divide by 1000 if you don't care about that level of accuracy). if you want to toss out time & tz (well server tz) cf datetimes are decimal days since it (& excel's) epoch, so doing an int() or round() on them will give you number of days. noLongerDecimalDays=int(yourCFDateObject); no need to format/decode anything. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331313 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
