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.