Hi,

I have just figured it out too, it took me days. I am working in SQL and I needed to read the database, specifically the CALENDAR table and the clndr_data field. This is the same as the data that you have above, it is in XER format as well.

So when you see the numbers...

(0||Exceptions()
((0||0(d|36126)())
(0||1(d|36153)())
(0||2(d|36311)())

You will note that there are empty brackets after the numbers. If someone is working on that day then the brackets would contain the data for the hours to be worked in that day. So there is no work happening on the above days.

This is what I search for "d|36126)())", but used the date that I had converted to a number.

First I converted todays date to a number and then double checked it in excel. If you put a date into excel and then change the format of that cell from date to number it will give you the equivalent number. In SQL I cast the date to an integer and used that number, but, the number was out by 1, not sure, so I manually added one as an offset number to ensure I had the right number before searching.

Next, I created a function to do a string search but included the empty brackets. If it returned 0 then it was a normal working day, and if it returned a value than then the resource was not working on that day.

Hope that helps,

Denise