Skip to main content
Topics#Lightning ExperienceFrage von Deepti Valiveti
Deepti Valiveti (abc) fragte in #Lightning Experience
26. Feb. 2021, 10:21

how to calculate the remaining days for current day and days in month

2 Antworten
  1. Abhishek Mudireddy (Salesforce)
    26. Feb. 2021, 13:43
    DOCUMENTATION

    Sample Date Formulas | Salesforce​

    https://help.salesforce.com/articleView?id=formula_examples_dates.htm&type=0&language=en_US&release=206.9

    Finding the Last Day of the Month

    The easiest way to find the last day of a month is to find the first day of the next month and subtract a day.

    IF(

      MONTH(  TODAY() ) = 12,

      DATE( YEAR(  TODAY() ), 12, 31 ),

      DATE( YEAR(  TODAY() ), MONTH (  TODAY() ) + 1, 1 ) - 1 

    ) 

     - 

     TODAY()

    Let me know if it helps you and close your query by marking it as solved so that it can help others in the future.

    Thanks.
Antwort schreiben...
0/9000