Technote Details :: Dates displayed incorrectly
Issue
My dates are displayed incorrectly. (e.g. 2007/3/201)
Reason
This happens because you are using ColdFusion and the MS SQL server. You have set your database date format in the InterAKT Control Panel to the date format displayed by the MS SQL console. However, the MS SQL console displays dates in the same format as the one set in Windows (Regional Settings from Windows Control Panel).
Solution
In the InterAKT Control Panel > Date Formats, set the database date format to YYYY-MM-DD, even if dates are displayed differently by MS SQL console. This is the correct format dates are stored in.
