Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
SELECT field, CASE WHEN CONVERT(DATE,field)>getdate() THEN DateAdd(year,-100,CONVERT(DATE,field)) ELSE CONVERT(DATE,field) END as theDate FROM yourtable