I have a calculated field that in SharePoint 2013 that is set to a date time format formatted to only display date. I have a date time field only to display date. How do I take the values in the calculated field and copy them to the date time field using the 2013 workflow?
Solved! Go to Solution.
Hi Lisa,
You could save the calculated field to a backing text field column and then update the date column via the workflow. There isn't an out of the box way that I know of to connect the calculated field directly to a date column, although I wish there were!
-Mike
Lisa,
Saw this and wanted to know what are you attempting to achieve? I thought you had the dates in the corrected format from the last question.
What is the end result and maybe we can work towards that.
I got the calculated field set up as you said. However, I already have date fields that need to be populated and that users will continue to populate manually. So I thought taking those calculated field values and moving them over would achieve that.
I was getting error messages simply copying the calculated field values. Its crazy. It shouldn't be this hard. I should just be able to update these dates.
Can you share what your list and workflow look like? In your workflow you could bring in the calculated date as a variable setup as a date. You should then be able to set item or update item and set the field to the variable. Is that not working?
Here ya go!
I changed this workflow when I couldn't get the date to work. I have it so it is pulling a text field from the source that has dates in it and putting it in a text field in the target. I figured then I could in SharePoint change the target text field manually to a date. But it kept throwing errors when I would try to update.
I think part of the problem is there are some dates that have an extra space after the month.
Its got to be something simple that is causing an issue. What does your list look like?