Skip to main content

Date Diff calculation should be inclusive of the start day

  • December 8, 2022
  • 0 replies
  • 12 views

I need to calculate the number of days in a customer’s subscription term. The term is 1/1/2022 - 12/31/2022.

Date Diff(Plan End Date, Plan Start Date, Days) = 364

This is an obvious error: it should be 365. The function should be inclusive of the start day.