Latest Enterprise DNA Initiatives

Holidays in Date Table

I have been working with Melissa’s extended date table but I cannot find instructions for adding holidays. Can anyone point me in the right direction?

Hi @jmolina,

I trust you’ll find all you need here in the Time Intelligence series.

I hope this is helpful.


Indeed, I can. Here’'s a blog entry on the topic, with a video I created at the end on how to develop your holiday table:

Also, Problem of the Week #1 showed how to create a perpetual holiday table.

Once you have your holiday table in place, when you invoke the query for @melissa’s Extended Date Table, it will ask for the column in your holiday table with the dates of the holidays.

Once you specify this, it will automatically incorporate the holiday dates into the relevant fields of the date table.

I hope this is helpful.

  • Brian

Hi @jmolina, did the response provided by the users and experts help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

Hi @jmolina, we’ve noticed that no response has been received from you since the 19th of March. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

Hi @jmolina, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

We’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!