Forum Discussion

Snowy34's avatar
Snowy34
Helper III
6 years ago
Solved

Exclude dates table Filter

Good day all,    Here we are back with a new issue, what I have is two data tables, the first table holds my records of the deliveries from order date to delivered date. What I will like to add a c...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Ensure that in the WH column of Table2, there are only unique values.  Also, in the Relatioinshop window, select Many to One and Singe.

Snowy34's avatar
Snowy34
Helper III
6 years ago

Ashish_Mathur 

 

Basically I need to get a number of days it has taken to deliver an item but excluding weekends and public holidays, this would be quite easy to do if I didn't have warehouses that are in different states. Meaning what is a public holiday in Wearhouse 666 not a public holiday in Wearhouse 222.

 

I created a table that holds all public holidays for each Wearhouse and I was hoping I could use that when figuring out my days taken to deliver an order.

 

I hope this clears out what my issue is.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

What problem do you run into when you impleent my suggested solution.  Please be specific.

  • Snowy34's avatar
    Snowy34
    Helper III
    6 years ago

    Good day Ashish_Mathur 

     

    Thank you for your help, in the end, I got it working using your approach 🙂 

     

    Regards

    Snowy

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    You are welcome.