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
SFDC n12SFDC n12 

Copying the value of formula field to another custom field

Hi,

I want to copy the value of a formula field which is of text data type to a custom field which is of date datatype.


Let me know how to achieve this 
Nagarjuna ReddyNagarjuna Reddy
Instead of custom field take another formula field with Date return type and follow the below formula

DATEVALUE( formula field Api name which is text data type that you want to copy)
Nagarjuna ReddyNagarjuna Reddy
If you dont want to use formula field, then you have to write a trigger updating the paticular custom field from  formula field..

Cheers..
SFDC n12SFDC n12
Hi,

I should have the custom field since user has to enter the values

my overall req was when the user enters the value in the date field only the mon th and year to be displayed

that was the reason i went ans created a formula field , i am fetching the format correctly but just need to populate it in custom field 

if i remove the custom field then user cant enter the value for it which is wrong
SFDC n12SFDC n12
let me know the sample code for trigger please