In Sharepoint, I want to trigger a workflow automatically every month which shows only the lists which has that particular months date

Question

Hi,

I am new to sharepoint... I have a question:

I have a list with many documents in it. I have a date column in that list. For each month I would like to view only that particular month's list (i.e) select the list which has that month in the date field. I would like the list to get updated each month automatically according to the date specified in the date field. For now I am doing it manually by changing the today's date which I have set. I would like to make this an automatic process each month beginning.

Could anyone help me rearding this. I hope my question was clear...

Thanks.. sharmi.

Answer 1

YOur questipn isn;t really clear to me, but I'll give it a go anyway. You could try to add calculated columns to the list, that display only the month part of the date in the desired column, by using the MONTH([Start Date]), where Start Date is the name of the column your date in it.

The part about the workflow is not clear at all, what do you want to do? IF all you want is to display that months items, then add the calculated column and the nfilter on it. Or, to go a step further, create 12 views on the list, one for each month, that filter based on the newly added calculated column.