Rollover fails silently with some states

[Ghislain Hachey]

All except pohnpei (who would not have used a workbook from a EMIS online rollover) still fail with cast type error.

‌

[Brian Lewis]

Reliably typecasting is tricky using the data pulled from the spreadhseet; especially with respect to dates. This turns out to open a bigger issue - the function TRY_CONVERT() isunavilabnle to us due to the current COMPATILITY_LEVEL of Pacific EMIS databases (100 everywhere).

Cleanest solution is to upgrade to Compatibility_level 110.

100 is the highest supported for SQL SERVER 2008. 110 is the highest for SQL SERVER 2012. Our lowest installtion is 2014 and not likely to ever require any backward compatility. Will create a new issue to manage this change - will need to be applied to development systems as well.

‌

[Brian Lewis]

#1236 resolves upgrade to Compatibility Level 110.

This allows a robust solution to date conversion in common.safeDate

‌

[Brian Lewis]

fix(census): staff rollover fails with cast error

Resolves #1234

→ <<cset cef98404821d>>