I am reading a excel .xls file with <cfspreadsheet
action="read"
src = "inv00075.xls"
sheet="1"
query = "the_data"
>,
I am trying to extract several dates and a dollar amount. The data that ends
up in the query for dates is suppose to be a count of days since jan 1 1900, so
I use a date add (Where P is equal to the query column) <cfset period_e_day =
#dateadd('D',P,"1 jan 1900")#> this results with a date that is off by two
days... Any ideas why the dates a re consistenly off by two days?
CF 9, windows server 2008, Oracle 11 is the system set-up
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345756
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
