You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
FROM OBSERVATION_FACT OBS WHERECONVERT(DATE,OBS.START_DATE) BETWEEN CAST('2020/01/01'ASDATE) AND CAST('12-31-2020'ASDATE)
The date literal '2020/01/01' on line 78 is the only time the floor for the one-year census period is written in yyyy/mm/dd format in the entire script. It will make find-replace in future maintenance of the script fail.
The text was updated successfully, but these errors were encountered:
CTSA-Metrics/InformaticsMetricACTSQLServer.sql
Line 78 in 17e9243
The date literal '2020/01/01' on line 78 is the only time the floor for the one-year census period is written in yyyy/mm/dd format in the entire script. It will make find-replace in future maintenance of the script fail.
The text was updated successfully, but these errors were encountered: