Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Custom Filter based on system date for a List View?

  Asked By: Donnell    Date: Feb 10    Category: Sharepoint    Views: 2948

I'd like to filter a sharepoint list view of tasks to only show items
for the "current payroll cycle", which is a calculation based on the
current week (Friday 5PM + 7 days).

Currently I can sort of do this with custom columns on the view that do
calcuations on current date, but this requires each task be updated each
day since [Today] isn't officially supported (I'm using the "create a
Today column and then delete it" hack). I also have to keep a bunch of
columns that contain bits of the calculation to determine the current
payroll cycle (julian days etc).

It seems to me a incredible shortcoming of sharepoint if I can't do
advanced filtering on a list based on current day. Can I create a filter
in sharepoint desinger that could do this? I basically just want a SQL
query kind of like this....

select taskname, duedate, priority, complete% from sharepoint_task_list
where duedate BETWEEN *calculation of friday before sysdate* AND
*calculation of friday before sysdate + 7*

Is this possible in designer? I've heard there's a query language called
CAML for sharepoint, but does that require custom code to use?

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Custom Filter based on system date for a List View? Or get search suggestion and latest updates.




Tagged: