Skip to main content

Issue:

I have a situation where I created a library that has a field called EmailDate that was created as a single text field in error.  I should have created the field as a Date Field.  700 documents later I was informed of this error. The current EmailDate field reads as Mon, 25 Jul 2106 14:44:09 -0500 as one example.

My goal:

  1. Create a field called EmailDate1 as a date field and update this new field with the value found in the Create field.
  2. I want to do a one time update thru a Workflow to update the 700 documents for the EmailDate1 field with the value found for Create.

Now in some cases the value found in Create may not actually be the correct Email Date, but for 97% of the time this will be an accurate value and for the purpose of this clean-up 97% is better than what exist today !

RoadMap ?:

Can someone give me some hints on how to do this...I am familiar with creating a query in Nintex, variables, loop, and some other functionality, but not sure what to do to get started on this one.  When reviewing via Google I may need to:

  1. Create Query for my 700 items
  2. Create variables for EmailDate1
  3. Loop and SetValue for EmailDate1 field to the value found for Create

Note I am not familiar with Set Value and this is just a guess that I should use Set Value to resolve my issue. confused.png

Hi

Your outline looks fine. 

To handle the risk of failure I would limit the query to items where emaildate1 is empty

That way you could just run the workflow again and it would start from where the error occurred. 

Use “Update item” to write your variable to the emaildate1 column. 

You might have to do some calculation or formatting of the data from the query before it can be used as a date.
emailDate.PNG

emailDate2.PNG

I am actually having a problem with the Update Item.  I set a Collection for the ID and Created Date.  A Collection Operation passes the date value to a date variable via using the Index of the ID.  Within the Update Item where varID is = to the ID of the list I then attempt to update the value of the column called to Email1 = to the date variable for the created date.

However, the workflow errors at the Update Item flow.  Any ideas....

Note the Query List does not error out; the For Each and Update Item are the only processes that display in yellow...

It turns out the issue was with the ID.  The WHERE clause needed to take the ID and match it against a TextVariable from the collection of where I stored the ID...Have no idea why tho..

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings