SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have 4 date fields and then 4 calculated fields off those 4 date field that I am using in a workflow email to just show =TEXT([Class Start Date],"mm/dd/yy") so that the date shows up in the correct way when the email is sent. When I enter in the dates on the non calculated fields and I click ok to submit the form it changes those dates to the date before the date I actually entered. Does anyone know why this is happening?

share|improve this question
" it changes those dates to the date before the date I actually entered" the DAY before or something else? – Ryan Jun 15 '12 at 7:33
Say I enter in 6/21 in the first date field and 7/5 in the second date field, it changes both of those dates to 6/20 and 7/4 – Caron Jun 20 '12 at 12:18
I am having the same issue. My calculated column stores the correct information based on the date originally entered, but when you view the dates later, they are a day before the original date. – John Jul 30 '12 at 16:16

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.