CODEWITHSUNDEEP
sharepoint
Satchie Kellon Funk
Satchie Kellon Funk

Reputation: 1

Issue with date and time value - Lists in Sharepoint

Is there a way to make "date and time" column in SharePoint so it will behave in this way:

-if date that is entered in that column is today, tomorrow that column will be empty.

To explain it a lil' bit better, lets put it this way:

That column is reservation column. User enters the date on which he will stop doing something:

column_1-column_2-column_3-RESERVATION_COLUMN

If today is 01.01.2012, and I will be doing something till 05.01.2012., I will enter "05.01.2012." in RESERVATION_COLUMN". When that day comes, or the day after it (isn't really mather) that column will be empty.

I tried some ways, but I didn't succeed. Any help?

Thanks in advance, K.

Upvotes: 0

Views: 266

Answers (2)

Anton Khritonenkov
Anton Khritonenkov

Reputation: 282

also you can create TimerJob, which will be executed one or few times per day. This timer job will query list items with your parameters, like items, where in the date field is value equals today or less then today. Then TimerJob will iterate and update this field.

Other, more difficult way is to write your own custom datatime field with specific behavior.

Upvotes: 0

Abhinav Ranjan
Abhinav Ranjan

Reputation: 146

Only way I can think of is using a workflow.

Using workflow -> Wait till day + 1 then Set field value to blank.

Upvotes: 1

Related Questions