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

Show Hyperlink against the Record in Datatable in LWC

Image
  Requirements : Show the case records in the data table. when click on case number it will redirect to the detail page Apex Class: showCaseRecordsinDatatable public with sharing class showCaseRecordsinDatatable {        @AuraEnabled     public static list<case> fetchCases(){         try {             return [Select Id, subject,CaseNumber, Description, AccountID, Account.Name,ContactID, contact.Name,Status, priority from case];                    } catch (Exception e) {             throw new AuraHandledException(e.getMessage());         }     } } --------Create LWC------- <template>     <lightning-card  variant="Narrow"  title="Case List" icon-name="standard:case">         <div class="slds-m-around_small">       ...
Read more

Send Email using Wrapper Classes in Salesforce.

Image
Send Email using Wrapper Classes in  Salesforce. Requirement :  Create a table in which there are list of contact name , email . when user select check box against any row of contact list and after that click on button then send the email to  that particular email id  <!--WrapperDemoTestOnContact-->  Create Visual force page <apex:page standardController="Contact" extensions="WrapperClsOnContact">     <apex:form >     <apex:pageMessages >     </apex:pageMessages>         <apex:pageBlock >             <apex:pageBlockTable value="{!wrapperObj}" var="x">                 <apex:column value="{!x.conobj.name}"/>                 <apex:column value="{!x.conobj.email}"/>                 ...
Read more

Get the record Count of all countable Sobjects in Salesforce

Image
  Salesforce: Get the record count of all objects Use case: A client wants to access the data volume for data migration and needs to get record counts from all countable objects in Salesforce Solution:  1) log in to Workbench 2) Go to Utilities > Rest Explorer 3) Do a GET call on this URI: /services/data/v56.0/limits/recordCount ( change 56.0 with the latest API version) 4) Check the result. Copy the JSON and convert it to CSV Note: 1) The Rest call result does not include uncountable objects and record count for deleted records in the recycle bin 2) Ensure your user has "View Setup and Configuration” permission
Read more