Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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
add comment

2 Answers

up vote 4 down vote accepted

Try this formula as default value :

=Today+1+(9/24)

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

=Today+1+(9/24)+(30/(24*60))
share|improve this answer
    
You are awesome!! Thank you!! –  Christopher Nov 22 '12 at 14:11
add comment

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
add comment

Your Answer

 
discard

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.