I realize that you got some good answers. I just thought I might mention that the errors you were probably getting (judging by your code example) was you were trying to treat the date() like a string. You merely needed to convert the date() using DTOC().

Hope this helps.