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

Say I'm currently using a Date/Time field for workflow purposes, the default value being Today+1. That gives the time at 12:00am tomorrow, which is great.

Is there a way to always give the default value to, say, 9am tomorrow (regardless of what time it is today)?

share|improve this question
up vote 4 down vote accepted

Try this formula as default value :


this should do the trick :)

times are stored as fraction, so using this method you can also specify minute, say you want to set default value as 9:30 AM then you can write

share|improve this answer
You are awesome!! Thank you!! – Christopher Nov 22 '12 at 14:11

Instead of only Today+1 use =Today+1+(9/24)

share|improve this answer
Eh, Diptarag already answered the same. sorry for duplicate. – Gomiunik Nov 21 '12 at 8:22
no worry buddy, answering is essential, who answers does not matter :) – Diptarag Nov 21 '12 at 8:26

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.