Skip to Content
Nov 28, 2011 at 03:23 PM

Date format in Excel Export


We do see different behaviour of date fields in exported Excel files and are not able to clearly identify why this happens.

And even after reading through dozens of documents, web pages and forum posts it is still not clear how this should work.

The questions are quite simple:

Can we expect that dates in exported Excel files (exported from for example the ActiveX viewer) will be formatted as per the format set during the design of the Crystal report or will it follow the Regional Settings on the PC where it is exported?

If it does not follow the Regional Settings is there any 'easy' way to accomplish that?

Thanks and regards, Stig