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)?


2 Answers 2


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


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

  • Eh, Diptarag already answered the same. sorry for duplicate.
    – Gomiunik
    Nov 21, 2012 at 8:22
  • no worry buddy, answering is essential, who answers does not matter :)
    – Diptarag
    Nov 21, 2012 at 8:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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