0

I need to create a formula field on createddate of user object to parse the month and year from it .But this field is not visible in formula merge options.But this field is visible on reports ....How to get my formula done on created date??

2 Answers 2

2

Unfortunately you can't do this. I can't find any documentation from Salesforce on this, but there's an existing answer on success.salesforce.com:

https://success.salesforce.com/answers?id=90630000000grZdAAI

It isn't available in the workflow formula editor either, so it looks like your only option is a regular field and a trigger to update the value whenever a record is created/updated.

-1
  1. MONTH(DATEVALUE(CreatedDate)) //for month 2.YEAR(DATEVALUE(CreatedDate)) //for year 3.DAY(DATEVALUE(CreatedDate)) //for day
1
  • I have no issues in formula ...I have issue on created date field ...when i use that field in formula i get invalid field Feb 6, 2014 at 6:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.