Date is wrong in attributes

[CynthiaLieberman]

We noticed that the Date field in the attributes is one day earlier than the actual submitted date. Is this fixable? Is there a work-around that allows me to have the actual date (I'm in Eastern Standard Time) rather than the "one day earlier date" in my attributes?

[DavidForbuss1]

We were having a similar issue and figured out that it was because one of the dates was being written using UTC time.  We're in Pacific Time so it's UTC minus 8 hours for us.  I'm guessing you'd be UTC minus 5.  Based on that you'd still be getting dates on the 15th so I'm not really sure what is going on in your case.  It might be defaulting to the whatever timezone was set in the database when it was originally spun up.  

[Anonymous User]

Thank you, David! We are still fiddling with it...

[CPoynter]

You can try doing a calculation on date to add / subtract the required number of hours to adjust your date. Otherwise this posting mentions an offset to adjust date/time.

[JamesTedrick]

Hi Cindy,

Just to check, the Date field you are highlighting is a 'Date' question?  If so, that is stored as midnight in the submitting time zone - if someone submits this in a timezone west of you, it may appear as the previous day.