Just an FYI if you are using the CONVERT with 112 you don't need the REPLACE statement the 112 does not return the results with the slashes(yyyymmdd).
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.