Skip to main content

Does anyone have a function for calculating the number of work days netween two dates taking into account the Holidays that are captured in the Calendar?

  • December 28, 2023
  • 2 replies
  • 108 views

miguel80
Semi-Pro III
Forum|alt.badge.img+3

Hi!

I need a function than calculates the difference between two dates (in hours or days) taking into account the hours and work days, and exeptions (holidays) established on the calendar screen. Does anyone have something like this?

I don’t want to make an overkill if someone already has it, if not, I’m planning on creating a function (code) that does that and can be used in the attributes of a custom field (self calculating), I will then use that custom field in my generic inquiry, the main issue is that I have to create a new field for every DateDiff that want to calculate…

Would anyone find this useful?

Thanks!

2 replies

Robert Sternberg
Captain II
Forum|alt.badge.img+7

Hi yes I think that would be very useful, it would be great if you would consider sharing with the community. 


meganfriesen37
Captain II
Forum|alt.badge.img+12

It would be great if Acumatica would add this as a feature