I have a sharepoint calendar web part storing employees attendance in it and also used for display it that "Attendance has been marked" on which I filtered the calendar based on created by, now I need to extract the dates for each employee when he was ABSENT...Please help!!

Hello,

Could you please tell us the column details of your calender list? Based on my understanding calculate column may help you to get the total absent of each employee.

Just let us know your list structure so we can help you

I have a date(carry today's date for each day, if employee is present) & employee name. I have only two columns..

Like:

2-july-2013    JOHN

2-july-2013    JACOB

2-july-2013    BOB

3-july-2013    JOHN

3-july-2013    BOB

4-july-2013    JOHN

.......&  so on for full month, Now Jacob is absent on 3rd july , so I need the details for each and every employees for every month. Like:

Absent Column: 

3 July  Jacob

4-july-Michael

......etc.

& I need the dates as mentioned above , not the total no. of days.

& for further, I want to send a reminder mail..that u have absent on this day , may be 2 days after(tentative)..

Regards

Mohit Jain

Hello,

You can create one calculate column to get date in "dd mmmm" format as shown in below: (you will get date like 12 July, 7 Aug etc)

I am assuming that you don't enter date in date column if employee is absent so date field is blank if no date is entered.

Now modify (or create new) view and add filter like:

"If date is blank".

Now you should see the expected result. Let me know in case any problem

Thanks Hemendra for your reply...But the scenario is I am not creating the item every day for every employee. It creates the item in calendar only when employee is present(Marked present)..How to get the date that is not there in a whole month..

Like: suppose My name is A, now today is 7 Aug. Today I marked present, as soon as I marked present it creates item in calendar Like:

A     7 Aug

Next day I will be absent and day after tomorrow I will be marked present-and a new item will be created in a calendar:

A    7 Aug.

A    9 Aug

.....& so on.

Now In the last day of month::  I need the list of absent days that for now on it is  

A    8 Aug.

....

Same as for each employee.....

Regards

Mohit Jain

Emkor Solutions Ltd.

Do you need that information to be available in sharePoint ?

If not, you might want to export the data to excel/access and then created logic to get the required data.

regards,

eric

> I am not creating the item every day for every employee

This is the key here. I think you can't achieve this without code because you can't find absent day if there is no entry in list. From my opinion, you can create a daily job, which will loop through all  employee in list and check the today entry. If there is no entry for employee then add a new item and keep date field blank.

Once you done it then my previous solution will give the report.

However there may be many more ways to achieve this with code but i don't find any OOTB way.

Hope it could help