Yeah, the solution is the same. You have to apply a format.
> I also have a download function, in there I have formatted the column with > spreadSheetFormatColumn. If I use the downloaded file to upload, it reads > 4 digits year. > But if I create a new spreadsheet to upload. > It only reads the last 2 digits of year. >From what I have read on the POI lists, if you do not *explicitly* set a >format for the cells (either manually or programatically with CF), Excel >assigns its default. For dates it is "m/d/yy". That pattern, is what CF uses >to format the query values. So with your downloaded file, it uses whatever >format you applied. Whereas with your brand new worksheet, there is no format, >so it is falls back on the default "m/d/yy". -Leig ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:349815 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm