Visit the official Paxata Documentation portal for all of your doc needs.

How to calculate networkdays in Paxata? Also, why is networkdays not supported in my version?

I am trying to calculate the networkdays between two dates.  I recognize that according to the documentation NETWORKDAYS is a supported function, but for some reason it does not exist in the version we are running:

2018.2.6.1.2519
Tagged:

Best Answer

Answers

  • MelanieMelanie Posts: 28 admin
    Hi there, NETWORKDAYS is a new computed column function that has been added in our 2019 release. Please contact your Paxata system administrators to determine the anticipated upgrade date for your site, which will enable this new functionality for you. Hope this helps!
  • Does anyone know of a means of making the calculation in the meantime?
  • MelanieMelanie Posts: 28 admin
    edited June 24, 2019 9:57PM
    To make this calculation, you will need to compute it based on DATEDIFF and multiplying by number of hours in a day. Here are some details from the help documentation on the DATEDIFF function:

    DATEDIFF

    Calculates the days, weeks, months between two dates.

    Syntax:


    DATEDIFF(DATETIME_1, DATETIME_2, INTERVAL)

    • DATETIME_1 is the date you want to start with.
    • DATETIME_2 is the date you want to end with.
    • INTERVAL is the interval type (minutes, days, years, etc.) you want returned.

      The following is a list of the recognized values for the INTERVAL value:

      • Years
      • Months
      • Weeks
      • Days
      • Hours
      • Minutes
      • Seconds
      • Millis









    Example:


    DATEDIFF(@Date [email protected], @Date [email protected], “months”)


    :

    Notes on use:
    The DATETIME you provide must be a datetime object, a column that contains a datetime object, or a function that returns a datetime object. The INCREMENT provided must be an integer. Millis accepts a maximum of +/- 2147483647.

    It is recommended you use the latest datetime value for the DATETIME_2. If you enter the earliest date as the DATETIME_2 value, the DATEDIFF function will return a negative number.

    DATEDIFF always rounds the result down to the nearest whole number. For example, if the difference between two dates is 3 years and 11 months, the DATEDIFF function returns the difference as 3 years.

Sign In or Register to comment.