I keep this on my desktop and find it really useful to remember things like:
“What’s the difference between Month & Year, MonthnYear, MonthEnding, and MonthCompleted?”,
“What field do I use to sort Short Month by so that it shows up chronologically rather than alphabetically in my visuals?”
“Is the IsHoliday field coded 1/0 or TRUE/FALSE”?
Also, @Melissa and I are doing a multi-part video series on the Enterprise DNA TV YouTube channel focused on using the Extended Date Table to simplify your time intelligence calculations. The first video in the series, How to Create a Holiday Table, is already up and the next two episodes, Creating the Extended Date Table and Date Harvest Deep Dive, should be posting soon.
Just adding some keywords to make this easier to locate via forum search: date table, extended, cheat sheet, time intelligence, fields, format, fiscal, year, calendar.
Question?
Our business is operates on various days/per week. As an industrial contractor, we have projects that work various work weeks. Our work week is defined by our contract obligations
4 days x 10 hrs/day = 40 hrs per week
5 x 8’s = 40 h/w
5 x 10’s = 50 h/w
6 x 10’s = 60 h/w
7 x 10’s = 70 h/w
7 x 12’s = 84 h/w
as well as day shifts and night shifts
can anyone help with the adding to the function to be able to provide additional parameters?
This would be a very valuable addition in my opinion. thanks
I’m pleased to announce the release of the new deluxe version of the Extended Date Table Cheat Sheet, an essential accompaniment to @Melissa’s awesome and recently revised Extended Date Table code.
Click here to obtain the new version, which now includes not only all the field names and examples for each, but field type and information on how to sort every field in the table.
We will update this with every major update @Melissa makes to the date table code.
We hope you find this to be a useful resource – feedback welcomed.
Please do not ask new questions in already solved threads, they are impossible to locate…
Always create a new Topic in the appropriate category and provide all relevant data and details (a picture is not very ‘support’ friendly a xlsx or csv in this case is)
Review the items in this category for additional tips and tricks to get the most out of this forum.
The link to the new version of the Extended Date table does not seem to work.
I have been given a direct link for download but the download does not work.
Any suggestions please?
