[SalesForce] How to i use created date in User object formula field

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??

Best Answer

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.

Related Solutions

[SalesForce] Extract year from date field

If you're using a date field, it would be YEAR(Field__c). However, if you're using a date/time field, you need to use DATEVALUE (e.g. YEAR(DATEVALUE(Field__c)). Finally, if you're trying to display it by itself, it needs to be a number return type. To make it back into a date, you'd have to use DATE: e.g. DATE(YEAR(DATEVALUE(Field__c)), 1, 1).

[SalesForce] Updating a Date Field with Last Day of The Month based on another Date Field

Your formula works fine for me. Just replace all instances of

YEAR(MostRecent_Actual_Install_Date__c) + 1

with

YEAR(MostRecent_Actual_Install_Date__c)

Sample input/output combos:

03-02-2016 / 03-31-2016
02-02-2016 / 02-29-2016
01-02-2016 / 01-31-2016
12-02-2015 / 12-31-2015

Best Answer

Related Solutions

[SalesForce] Extract year from date field

[SalesForce] Updating a Date Field with Last Day of The Month based on another Date Field

Related Topic