Timestamp For Access?

Is there a way of getting a timestamp that Access will accept? I used the date() function to get the current date and tried to stick it into a field with the Date/Time data type (and a Long Date format) and got a type mismatch error. If I'm not being clear enough, just tell me. I tend to be quite incoherent sometimes. =) Thanks for any help.