function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
mikkamikka 

How to insert minutes in Date/Time field formula field

Hi guys,

 

Just a question on date/time field formulas. I created a formula field (X3_days_before_due_date) that will get the days before the due_date__c field value. So far here's what I've gone through:

 

Due_Date__c -3

 

Now, my problem comes on the time field. I want to add 16:00 after the said date formula. Please note that 16:00 time is a constant value and I will use this field in workflow alerts.

 

Do you guys have some idea how can I add this time so that this will be:

Current date:                      Oct.14,2010  17:44

3 days  before due date:  Oct.11,2010  16:00

 

Thank you very much!!!!