2

I am looking to create a formula date/time field that will give me for example 12/05/2014 3:00 PM for today and then tomorrow it changes to 12/06/2014 3:00 PM. The date but not the time will change daily.

1
  • 1
    what have you tried? folks at SFSE appreciate some effort on the part of posters and then will jump in. Have you read: help.salesforce.com/… ?
    – cropredy
    Dec 6 '14 at 1:10
1
DATETIMEVALUE(DATE(year(DATEVALUE(CreatedDate)), 
month(DATEVALUE(CreatedDate)), day(DATEVALUE(CreatedDate)))) + 7 + 11.50/24

This will default to date : + 5:00pm

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.