Formula to find the day difference between two Dates

Scenario: In the vendor record, we have a status called ‘Charity Status’. While creating a vendor record, the status is set to ‘Initial contact’. The status of the vendor will converted to ‘Approved – Active’ after a time period. So the requirement is to calculate the number of days from the ‘Initial contact’ date/ create… Continue reading Formula to find the day difference between two Dates

To find the Days difference between the two Dates

When we need to find the days difference between two dates use the below-added code. Add the configuration module to the script The comparing date should be in the same format. Here if ‘todayDate’ is 30/05/2023, and the ‘referenceDate’ is 28/05/2023, then the ‘differenceInDays’ value will be ‘2’. If ‘todayDate’ is 28/05/2023, and the ‘referenceDate’… Continue reading To find the Days difference between the two Dates