This is a really simple and effective script!

One question I had is how would the function know the difference between 'Mon' and 'MON' if the DB collation is case-insensitive?

When I ran the following code on my case-insensitive DB it still gave me a 6...

SELECT CHARINDEX('Mon','YYYY-MON-D')