Announcement

Collapse
No announcement yet.

Extended formular function datetime\diff

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Extended formular function datetime\diff

    Hello Devs,

    datetime\diff(VALUE_1, VALUE_2, INTERVAL_TYPE)​ returns the difference between two dates or datetimes by the given INTERVAL_TYPE.

    To calculate only workdays, there should be a attribute for a weekend number like the EXCEL function NETWORKDAYS.INTL.

    Please take a look at the added link, for an example implementation.


    Best regards
    Martin
    NETWORKDAYS.INTL returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. Weekend days and any days that are specified as holidays are not considered as workdays.

  • #2
    Unlikely to be implemented for this function.

    You can use ext\workingTime\getWorkingDays instead: https://docs.espocrm.com/user-guide/...mula-functions

    Comment


    • #3
      Originally posted by yuri View Post
      Unlikely to be implemented for this function.

      You can use ext\workingTime\getWorkingDays instead: https://docs.espocrm.com/user-guide/...mula-functions
      I didn't know this function before. It's work like a charm. Thanks for the hint!

      Comment

      Working...
      X