Skip to main content
Topics#Lightning ExperienceQuestion de Deepti Valiveti
Deepti Valiveti (abc) a posé une question dans #Lightning Experience
26 févr. 2021, 10:56

How to calculate last date of the current month

3 réponses
  1. Anudeep Gopagoni (Salesforce)
    26 févr. 2021, 11:10
    Hi Deepthi, 

    The following formula will give you last date of the current month 

     

    IF( MONTH( TODAY() ) = 12, 
    DATE( YEAR( TODAY() ), 12, 31 ), 
    DATE( YEAR( TODAY() ), MONTH( TODAY() ) + 1, 1) - 1)

    Also, Check out salesforce documentation on Sample Date Formulas

    Let me know if this helps, if it does, please mark this answer as best so that others facing the same issue will find this information useful. Thank you
Rédiger une réponse...
0/9000