Highlighted

CFSpreadsheet and date delimiter character

New Here ,
Jan 17, 2017

Copy link to clipboard

Copied

I have a spreadsheet with date columns in dd.mm.yyyy 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 "dd.mm.yyyy" 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.

Views

134

Likes

Translate

Translate

Report

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

CFSpreadsheet and date delimiter character

New Here ,
Jan 17, 2017

Copy link to clipboard

Copied

I have a spreadsheet with date columns in dd.mm.yyyy 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 "dd.mm.yyyy" 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.

Views

135

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jan 17, 2017 0

Have something to add?

Join the conversation