Activity › Forums › Salesforce® Discussions › How to convert date time to date using formula field? Tagged: Date Field, Date Value, Datetime, Field Value, Salesforce Apex, Salesforce Custom Field, Salesforce Formula Field, Salesforce SOQL Salesforce® Discussions How to convert date time to date using formula field? Posted by Naman on April 30, 2016 at 6:06 PM How to convert date time to date using formula field? Jogender replied 9 years, 11 months ago 3 Members · 2 Replies Date FieldDate ValueDatetimeField ValueSalesforce ApexSalesforce Custom FieldSalesforce Formula FieldSalesforce SOQL 2 Replies Himanshu Member May 24, 2016 at 9:51 AM Hi Naman, you can use this formula to convert the datetime to date. DATEVALUE( “YYYY-MM-DD” ) [adinserter block='9'] Jogender Member May 24, 2016 at 10:54 AM Hi Naman, You can use the below formula somewhat similar to above by Himanshu for your standard/custom fields. DATEVALUE(YourField) Log In to reply. Public All Members My Connections Only Me PublicAll MembersMy ConnectionsOnly Me Public All Members My Connections Only Me