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
udayarangareddy mekalaudayarangareddy mekala 

FORMULA FIELD1

hi
I created one date/time field,i want to create one date/time formulafield with mm/dd/yyyy/hh:mm:ss.plz send me formula
Best Answer chosen by udayarangareddy mekala
salesforce mesalesforce me
Hi ranga...

DATETIMEVALUE(TEXT(YEAR(Start_Date__c))+"-" +TEXT(MONTH(Start_Date__c))+"-" +TEXT(DAY(Start_Date__c))+" "+TEXT(VALUE(LEFT(Start_Time__c, 2))+ 7)+  MID(Start_Time__c,3,3)+":00")


                                                    OR


https://help.salesforce.com/HTViewHelpDoc?id=formula_using_date_datetime.htm

All Answers

salesforce mesalesforce me
Hi ranga...

DATETIMEVALUE(TEXT(YEAR(Start_Date__c))+"-" +TEXT(MONTH(Start_Date__c))+"-" +TEXT(DAY(Start_Date__c))+" "+TEXT(VALUE(LEFT(Start_Time__c, 2))+ 7)+  MID(Start_Time__c,3,3)+":00")


                                                    OR


https://help.salesforce.com/HTViewHelpDoc?id=formula_using_date_datetime.htm
This was selected as the best answer
udayarangareddy mekalaudayarangareddy mekala

i m not understanding this one ie 
TEXT(VALUE(LEFT(Start_Time__c, 2))+ 7)+  MID(Start_Time__c,3,3)+":00")
plz explain me.
THANKS

RANGA