Skip to main content
Topics#Data ManagementDomanda di Philipp Mathis
Philipp Mathis ha fatto una domanda in #Data Management
26 ott 2017, 11:55

formula that gives me always last day of current year

For a calculation I always need the last day (e.g. 31.12.17) of the current year I'm in.

 

What would be the correct formula?

 

Greetings,

 

Philipp
8 risposte
  1. Chris Duncombe (Imprivata)
    20 nov 2017, 13:00
    @philipp

     

    You would just need to replace TODAY() with the start date field.  Somethign like this

     

     

    DATE(YEAR(Start_Date__c), 12, 31)

     

    You will just need to make sure you use the proper API Name of your field

     

     
Scrivi una risposta...
0/9000