I was just having trouble with this myself. Try putting quotes on the datepart variable ("d" instead of dd).