interesting article, thanks., but what about just using some variation on

select replace(convert(varchar(30), getdate(), 103, '/', '\')

( i don't have SQL server in front of me to check I've used the right format - I can't recall them all, for which reason i have a couple of UDFs like this at work...)