Skip to main content
Topics#Lightning ExperienceDeepti Valiveti の質問
Deepti Valiveti (abc) が「#Lightning Experience」で質問
2021年2月26日 10:56

How to calculate last date of the current month

3 件の回答
  1. Anudeep Gopagoni (Salesforce)
    2021年2月26日 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
回答を記入...
0/9000