i tried INT(Lead.[Date Created]) but get a 3464 error, the same as if i used datevalue(Lead.[Date Created]).

i forgot to mention that when i use Lead.Date, everything works perfectly. if i use Lead.[Date Created] i get nothing but blanks.

Both Int(Lead.Date) and Lead.Date work perfectly.
Both DateValue(Lead.[Date Created]) and INT(Lead.[Date Created]) fail with runtime 3464
Lead.[Date Created] gives me blanks