1 Reply Latest reply on Aug 16, 2016 5:39 AM by Tom W

    Use Scalar Functions in Tableau to calculate date difference

    Zandile Tshuma

      Hi All,

       

      I am trying to create a  field that calculates a DATEADD function on a date field that's in Table_A and the addition should  exclude weekends and holidays. A scalar function [dbo].[fn_Workdays] to exclude  weekends and holidays is already built within the SQL database. Please could you help me with the syntax/method to call this function in Tableau?

       

      Thanks in advance

      Zandile