Hello Kirsten,
Apologies for reviving an old post but did you ever get an answer to this? I have the same issue!
Cheers,
Gino
This is a little tricky because so many data formats have different storage formats. Date fields in dbf (shapefiles) don't even support time!
There are some good examples in the help here:
Thank you for your response...Embarrassingly it turned out to simply need the quotation marks. I am using inline variables so I just changed it from %Observation Date% to '%Observation Date%' and it worked.
Cheers
Gino