Hi,
As per the question it is not clear whether you have a constant year end date value for your company or different end dates for different companies.
In case you have a constant year end date value for your company then you don’t need to have a separate Date Time field to store the end date, instead you can directly use the hardcoded value to find the difference between the Start Date and End Date programmatically either using C# or JavaScript.
Using C# code.
You can use the below code to find difference between two dates.
• Difference in Days.
int numOfPassedInvoices = (endDate - startDate).TotalDays;
• Difference in Weeks
(Use Math.Truncate only if you do not consider the current period and if you want to consider the current period use Math.Ceiling)
int numOfPassedInvoices = Convert.ToInt32(Math.Truncate((endDate - startDate).TotalDays / 7));
• Difference in Months
int numOfPassedInvoices = Convert.ToInt32(Math.Truncate((endDate - startDate).TotalDays / 30.4));
• Difference in Years
int numOfPassedInvoices = Convert.ToInt32(Math.Truncate((endDate - startDate).TotalDays / 365));
Using JavaScript.
The below code is to find the year difference.
var startDate = new Date();
var endDate = new Date("01/01/2023");
var diffDays = Math.ceil( parseFloat((endDate - startDate) / (1000 * 60 * 60 * 24 * 365), 10));
To find difference in days remove the 365.
To find difference in weeks replace the 365 with 7.
To find difference in Months replace the 365 with 30.4.
However if you do not have the constant end date value and you have different companies records with different year end, in that case you need to have a separate field to store the End Date.
Now to find the difference you can create a Calculated DateTime fields as shown below.
The calculated field will provide multiple type of function to find difference in Days, Weeks, Months and Years etc.
In case you do not want to have the calculated field then you can use the C# or JavaScript code provided above.
Hope this helps.
Thanks!
