ProjectWise Administrator Help

System Variable $DATE$ Does Not Work with British SQL Server

If you are using the $DATE$ system variable in ProjectWise attributes and you are using British SQL Server, the date is incorrectly saved in the database (month is used as a day, and day as a month), and if the day of the month is less than 12 it produces an error.

Workaround 1: Change the default language to “English” in ODBC settings.

Workaround 2: Use the $DATETIME$ system variable instead.