cancel
Showing results for 
Search instead for 
Did you mean: 
burkslm
Nintex Newbie

Calculated Field and Date Time Field

Jump to solution

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?

0 Kudos
Reply
15 Replies
Automation Master
Automation Master

Re: Calculated Field and Date Time Field

Jump 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

Reply
Community Manager Community Manager
Community Manager

Re: Calculated Field and Date Time Field

Jump to solution

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.

Reply
burkslm
Nintex Newbie

Re: Calculated Field and Date Time Field

Jump to solution

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.

0 Kudos
Reply
burkslm
Nintex Newbie

Re: Calculated Field and Date Time Field

Jump to solution

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.

0 Kudos
Reply
Community Manager Community Manager
Community Manager

Re: Calculated Field and Date Time Field

Jump to solution

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?

0 Kudos
Reply
burkslm
Nintex Newbie

Re: Calculated Field and Date Time Field

Jump to solution

Here ya go!

DateWorkflow.jpg

Reply
burkslm
Nintex Newbie

Re: Calculated Field and Date Time Field

Jump to solution

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.

Reply
burkslm
Nintex Newbie

Re: Calculated Field and Date Time Field

Jump to solution

I think part of the problem is there are some dates that have an extra space after the month.

Reply
Community Manager Community Manager
Community Manager

Re: Calculated Field and Date Time Field

Jump to solution

Its got to be something simple that is causing an issue. What does your list look like?

Reply