1 Reply Latest reply on Oct 31, 2014 11:44 AM by Shawn Wallwork

    Date Diff of two date fields without holidays or weekends

    Alexis Jasinski

      I have two data sources. Once is an Excel file and one is a SQL. The Excel file has the data I need to analyze. The SQL file has all dates from 1900 - 2050 and has a 'Yes/No' dimension which allows you to only see business days. I created the following DATEDIFF calculation to determine the number of days between start and finish: DATEDIFF('day',[Date Start],[Date End] )

       

      I created a relationship between my excel Date End field and the SQL date field, then I dragged the IS BUS DAY to the filter and selected yes. The data no longer displayed. Please help!