You need to sign in to do that
Don't have an account?
mw6
how to populate the last date of this to a date field using formula
I have a field called 'Expiry_Date__C. Can anybody help me to write a formula to populate the last date of this to a date field using formula
Create formula field with eturn type date and use following code
Thank you,
Amol Salve
Salesforce developer
All Answers
Create formula field with eturn type date and use following code
Thank you,
Amol Salve
Salesforce developer
I tried and it seems the date is showing 6 months later. I want to populate 31/12/2017 to expiry date when a record is created, is there any way
You mean ,you want to set the last day of the years as in the start date? or you want to add 1 year to the start date as expiry date?
To just set the last day of the same year,
To add one year to the start date
Thanks and Regards,
Shiva RV
change Start_date__c with you expiry date fieid..the above code is working fine in my fornula field
Thank you
Amol Salve
Salesforce Developer