Loading

fetching sharepoint list items using caml query

Pradeep Kumar

I created a list of birthdays with column Datetime that stores birthdays of employee (e.g. 20/10/1994). I want to get the date and month from the column of a custom list.

I want to run a timer job whenever current date is equal to the date of the column.

For that I need a caml query that fetch particular list item based on current date and month.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Deepak Solanki11y ago
Accepted answer
Hi Pradeep,

A simpler approach is:
1. Create a new 'Calculated column' of 'Single line text' Type in the same list.
2. Put following formula for calculated column, DOB should be replace with your actual column name.
=CONCATENATE(TEXT([DOB],"DD"),"/",TEXT([DOB],"MM"))
3. In your timer job, get current date and format it is same string format "DD/MM"
4. In timer job compare, if current Item's "DD/MM" matches with job's current date "DD/MM" -> perform your operation.

Regards,
Deepak