configuring status list using date column, if greater than [date column] status goes red

Question

I am using a status list that is pulling from another sharepoint list, I would like to use a date column labeled "Due Date" and tell the indicator to turn red when the "Due Date" has passed...

This is in sharepoint 2010:

I have selected - Percentage of list items in the view where:

Due Date
is greater than
Current date? <--- this is the field where I cannot figure out how to make this work, what formula text am i putting in there?

Thanks in advance

I recommend looking at these questions: http://sharepoint.stackexchange.com/a/10217/1529 http://sharepoint.stackexchange.com/questions/12341/how-can-i-display-a-message-on-a-list-item-when-within-x-days-of-a-date http://sharepoint.stackexchange.com/questions/45951/how-can-we-create-and-calculate-a-due-date-today-7-column-in-sp-2010 — Stu Pegg, May 08 '13 at 09:51

score 1 · Answer 1 · answered May 08 '13 at 09:15

1

Where are you doing this? In SPD? SharePoint has a constant [Today] which should provide what you need.

answered May 08 '13 at 09:15

Dave Paylor

4,019
2
14
8

was doing this in sharepoint, just tried it...thx! – Vol May 08 '13 at 13:34

configuring status list using date column, if greater than [date column] status goes red

1 Answers1