CFSpreadsheet and date delimiter character

New Here ,
Jan 17, 2017 Jan 17, 2017

Copy link to clipboard


I have a spreadsheet with date columns in format. This is set without asterisk in Excel so that the format will not respond to regional settings.

When I output the spreadsheet query on my local computer, everything works fine, I get the dates in "" format like I should.  But when I upload the same code to the server and output the spreadsheet query, the date gets outputted in "dd\.mm\.yyyy" format. So instead of dots, I get backslash dots as a separator.

Any ideas what might be causing this?

The main differences between my local computer and server are OS (Windows 8.1 vs. Windows Server 2008), CF Version (11 vs 10), Java version (1.7.0_55 vs. jre1.8.0_45), to list some. Instead of version difference, this might be some java argument, coldfusion setting or os setting issue as well, but I'm not sure where to even start looking.







Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
no replies

Have something to add?

Join the conversation