Skip to main content

📆 How to Get the Start and End Date of the Previous Quarter in Apex ?

 When working with Salesforce data, it's often necessary to filter or report on records from a specific quarter. If you're looking to retrieve the start and end dates of the previous quarter based on the current date, here’s a simple and reusable Apex utility you can use.

🔧 Apex Utility Methods

Below are two helper methods:

  1. getStartDate() — Calculates the start date of the previous quarter.

  2. getEndDate() — Calculates the end date of the previous quarter, based on the start date.

// Helper method to get the start date of the previous quarter
private Date getStartDate() {
    Date today = Date.today();

    Integer currentYear = today.year();
    Integer currentMonth = today.month();

    // Determine the first month of the previous quarter
    Integer previousQuarterStartMonth = ((currentMonth - 1) / 3) * 3 + 1 - 3;

    // Adjust the year if the previous quarter falls in the previous year
    if (previousQuarterStartMonth <= 0) {
        previousQuarterStartMonth += 12;
        currentYear--;
    }

    // Return the first day of the previous quarter
    return Date.newInstance(currentYear, previousQuarterStartMonth, 1);
}

// Helper method to get the end date of the previous quarter
private Date getEndDate() {
    Date previousQuarterStartDate = getStartDate();
    // Add 3 months and subtract 1 day to get the last day of the quarter
    return previousQuarterStartDate.addMonths(3).addDays(-1);
}

🧠 Explanation

  • The start month of the current quarter is calculated using: 

((currentMonth - 1) / 3) * 3 + 1

  • Then we subtract 3 to move to the previous quarter.

  • We adjust for year boundaries (e.g., if today is in Q1, the previous quarter is in the previous year).

  • The end date is simply 3 months after the start, minus one day

✅ Example

If today's date is April 25, 2025, then:

getStartDate() will return January 1, 2025

  • getEndDate() will return March 31, 2025

Comments

Post a Comment

Popular posts from this blog

How to Create a Tooltip in Lightning Datatable ?

Imagine you have a datatable displaying a list of Contact records , and one of the columns shows the Account Name . The Account Name is a hyperlink that allows users to navigate to the Account record page. But what if users want to take a quick glance at some key Account fields —like Phone or Address—without navigating to the Account record? In Salesforce Classic, this was achieved using the Mini Page Layout feature from standard page. However, in Lightning Experience, we can implement a similar feature by adding a tooltip to the data table. Solution Overview: We’ll create a Lightning Web Component (LWC) that: Displays a data table with a clickable Account Name . Provides a tooltip that shows the Account's Phone and Address fields when users hover over the Account Name. Implementation Steps: 1. Data Preparation We need to retrieve the following fields for each Contact and its associated Account: Contact Fields : Name, Phone, Email Account Fields : Name, Phone, Billing Addre...
Post a Comment
Read more

Lifecycle hooks in LWC

There are 3 phase of LWC component  1. Mounting  A. constructor, B. connnectedCallback C. render D. renderedCallback 2. UnMounting  A. disconnectedcallback 3. Error  A.errorcallback Note - render is not lifecycle hook, it is protected method of Lightning element class. Mounting Phase LWC Creation and Render Life cycle Constructor Method ·        This method called when component is instantiated and It flows from parent to child component. ·        Need to call Super() inside constructor method ·        Can’t access any component properties or child component because it’s not ready yet. ·        Host element can be accessed through “this. template” inside constructor method. ·        Don’t add any attributes to host inside constructor C   constructor (){          super (); //...
Post a Comment
Read more

Style in LWC

 Following are the ways we can apply in CSS in LWC. 1. Inline CCS Inline CSS is not recommended approaches, it is take highest priority among all CSS. style="color:green;font-size:10px;" is inline CSS added to div < template >     < lightning-card title = "Inline CSS" >         < div >             < div style = "color:green;font-size:10px;" > This is inline Style div </ div >         </ div >     </ lightning-card > </ template >  2. External CSS style can be applied to an elements such as h1, p,div span etc. It can applied to class using "." notation. for example .user{} It can also be applied to pseudo class.  for example .user:hover{} Id locator is not being used in LWC to apply style To apply external css, need to create separate CSS file, file name should be exactly matched with component name. for example - If component name is ...
Post a Comment
Read more