Get Last day of Month

Get Last day of a month (28, 29, 30 or 31)?

Formula

DAY(ADDMONTHS(DATE(YEAR(DateField__c), MONTH(DateField__c),1),1)-1)


The trick here is to take the 1st of the month and year of the date field, add 1 month to it and subtract 1 day.

For example, if my date field is March 3rd 2022, the formula will add 1 month to March 1st 2022 and will return April 1st 2022. We then subtract 1 day to get March 31st 2022.


Comments

Post a Comment

Popular Post

How to use Comparable Interface in Salesforce

Image
The Comparable interface use for sorting : Lists that contain non-primitive data types, that is, Lists of user-defined types. In Apex you need to implement the Comparable interface with its compareTo method in your class. When a class implements the Comparable interface it has to implement a method called compareTo().  In this method the code has to be verified if two objects match or if one is larger than the other. Class Code global class  CamprableInterfaceExampleController {     public List<WrapperClass> WrapperList {get;set;}        public CamprableInterfaceExampleController () {         WrapperList = new List<WrapperClass>();         WrapperClass s1 = new WrapperClass('Sumit', 22);         WrapperList.add(s1);                  WrapperClass s2 = new WrapperClass ('Amit', 15);         Wrap...
Read more

Update Contact Mailing Address with Account Billing Address on Custom Button

Image
Requirement:  On Account Detail Page is there is a Custom Button named Copy Address, When We click on this button then Billing Address of Account record is updated in all Contacts of that Account in Mailing Address. Solution : There are 3 solution  1) First one is write the trigger and invoke at custom button 2)  Call javascript code on Custom Button 3) Invoke Web service on Custom Button. I am explaining 3rd . Firstly Create a Apex Class: Class Name : UpdateContactAddress global class UpdateContactAddress {    webservice static String processDetails(String accID){          List<Account> lstacc =[select id,BillingCity,BillingCountry,BillingState from Account where ID =:accID limit 1];      system.debug('acc====='+lstacc);      List<Contact> lstofcont =[select id ,MailingCity,MailingCountry,MailingState,MailingPostalCode,MailingStreet       from contact wh...
Read more

Salesforce Spring 16 Release Exam (Maintenance Exam Q&A) for Developer 201 Admin

Spring 16 Salesforce Admin 201 Maintenance Exam 1. Which areas are calculated for the Health Check score? Choose 2 answers A. Number of users B. Session Settings  C. Profiles and Permissions assigned D. Password Policy E. Login attempts 2. What key user access data is included in login forensics? A. Who logged in from a new browser more than once in a day. B. Who logged in more than the number set in the profile. C. Who logged in during business hours. D. Who logged in more than the average number of times. 3. What is true regarding the new Data Loader? A. It has a new column flagging duplicate files. B. It supports Web Server OAuth Authentication for Windows or Mac. C. It has downloadable add-ons published through the AppExchange. D. It works with all legacy security protocol. 4. What does the Customize Application permission setting allow? A. To create article types. B. To edit contract settings. C. To modify custom picklist values. D. To create a...
Read more