Wednesday, 02 August 2006
Crystal Reports: not picking up correct date format
i'm part of the dd/MM/yyyy world, and that often means running into problems when using software developed with MM/dd/yyyy defaults, such as crystal reports.
i have all the report options set to use the system defaults, which are regionally set to ireland in windows, but that isn't enough, the dates still come out in MM/dd/yyyy format. i have the date + date/time fields customised within crystal reports to dd/MM/yyyy but that isn't enough either. with lots of hours googling and no answers that worked, i resorted to searching the registry and found that some of the user accounts were still using US regional settings. If you look in HKEY_USERS > you see a list of all the account IDs on the computer. My guess is that crystal reports must use the SYSTEM account or another non-interactive account, and it takes the regional settings from there. So if you search for sShortDate in the registry, you will find all the appropriate settings and can replace the MM/dd/yyyy values with your preferred format.
i had to reboot to get it to take effect.
Wednesday, 02 August 2006 20:45:07 (GMT Daylight Time, UTC+01:00) .Net General | Asp.Net | Windows Server