I think you're almost there. But instead of "today's date" you need to use the GETDATE() function which returns the current Date/Time.

Your other problem might be that you've spelt 'friend'...