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
L2BrewL2Brew 

Cross Object Formula on Oppty referencing standard date field on Account

I'm trying to create a simple cross-object formula on the Oppty to reference Last Activity on Account.  I have the formula working using the TEXT function and refencing the date field, TEXT(Account.LastActivity), but it's formatting the date as 2017-01-20 when it comes over.  I would prefer it be formatted like other date fields in Salesforce as 01/20/2017.  Any idea what function I would use for that?
Best Answer chosen by L2Brew
Saurabh BSaurabh B
Hi Laura, when you create a formula field, you should select data type as "Date" and not "Text". After you selected "Date" data type, just add Account.LastActivityDate as formula and that should do it.

Please mark this as Best Answer if it helps you...