You need to sign in to do that
Don't have an account?
Ishan Singh 4
I want to extract month and date from formula field(date type) in to another formula field(date type) which will include current year.
Eg:
Date of Birth(Date field) : 26-Jan-1996
New formula field (Date Type) - Day + Month + CurrentYear
Output of new Formula field : 26-Jan-2020
Date of Birth(Date field) : 26-Jan-1996
New formula field (Date Type) - Day + Month + CurrentYear
Output of new Formula field : 26-Jan-2020
You can use the functions DAY( date ), MONTH( date ), and YEAR( date ) to return their respective numerical values and build your formula accordingly
This document has some examples that you can refer to https://help.salesforce.com/articleView?id=formula_examples_dates.htm&type=5
Anudeep