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
Jennifer Thomas 23Jennifer Thomas 23 

Date/Time Field formula to convert to formal date

I am having a hard time coming up with a formula. I have a date/time field that would display 11/05/2018 11:00am or something similar. I need to create a formula field that would read that date/time field but instead display it as November 5, 2018 11:00am
Raj VakatiRaj Vakati
Use Text Function like below
  
TEXT( MONTH( date ) ) & "/" & TEXT( DAY( date ) ) & "/" & TEXT( YEAR( date ) ) )  +' '+ TEXT( TIMENOW() )

ref  this link 
  
https://help.salesforce.com/articleView?id=formula_using_date_datetime.htm&type=0

https://help.salesforce.com/articleView?id=formula_using_date_datetime.htm&type=0
Jennifer Thomas 23Jennifer Thomas 23
So I have the date time field that is to display my next scheduled meeting including the time of the meeting. I use this in email templates so I want it to read more professionally. I am using the suggested formula in the field and am getting a syntax error "Incorrect parameter type for function 'MONTH()'. Expected Date, received DateTime" Any thoughts?
KiranMKiranM
Hi Jennifer,

try replacing MONTH(date) with MONTH( DATEVALUE( date/time ) ) 

Refer : https://help.salesforce.com/articleView?id=formula_using_date_datetime.htm&type=5