0

Is there a way to set a field with [Today] date and not have it change once it is set.

Thanks Kim

1
  • 1
    Any reason why you cannot just retreive the value from the OOTB "Created" field? That field will contain the exact time the list item was created Apr 12, 2013 at 7:41

3 Answers 3

1

I have answered this question in another thread.

In general, you have to check if this field is empty before setting a value to it.

However, it is impossiple to check if a Date field is empty and you have to set value of your Date field to a String variable and then you can check if this String variable is empty.

Hope this approach could be used in your case. If so, please, don't forget to upvote and mark as answer :-).

1
  • Could you give me an example of setting the Data Value to a string? Would my step be: If Status = Setup, set Date to Today, then set the variable. Not sure what to do after that to check. I can get it to work using a hidden field, but I'd really hate to have to create another field.
    – kim
    Apr 12, 2013 at 14:50
0

You can update the field of a List Item in Workflow by using Update List Item action and setting the date column to Current Date

However permissions on columns are not permissible in SharePoint, what you can do is Hide this date column from the List/Library Forms by going into

List Settings -> Advance Settings -> Allow management of Content Type = Yes

Now,

Back to list settings -> Under Content Types -> click Item -> click the date column -> check Hidden

This will hide the column from been updated by forms...

2
  • If I hide the Date field can I have a Text field that is updated when the date is set showing the date? I want the date to show so they user will know when the date is set. What I ended up doing is creating a Y/N field set to Y, update the date field then set the Y/N field to N and hid the Y/N field.
    – kim
    Apr 12, 2013 at 14:35
  • Do you have InfoPath forms available? It will be easier if you modify the form in InfoPath.. you will need Enterprise SharePoint for that! Apr 16, 2013 at 20:11
0

You can create a date field in your list and assign it a workflow that will run at item create or change, and check field is empty with if statement then set it with workflow comment 'Update List Item'. You can give it the Today value.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.