I don't know what you mean by ...used the date function...
That fn requires three parameters: a year 1900 - 9999, a month 1 - 12 and a day 1 - 31

What formula/function did you actually use?