Skip to main content
Nintex Community Menu Bar

We have a List view using the Method for Workflow Reporting Service (List) : List Activity Instance Destinations and the Finish Date shows 1/1/1900.  When I go into the view and attempt to create an expression to replace the 1/1/1900 to a null value the field is locked out and says I can't use it because of circular references.

 

Is there a way to make that show as null if it hasn't been updated ?

 

 


15895i0BE3C546E3BBA2A6.png

I think a solution to this could be to add an additional Data Label column to the right or left of Finish Date column. Then add the expression you created to your new column (you could also title this column Finish Date) and hide the Finish Date column. This way your expression is looking at the old finish date column but updating the new one, now it won't be a circular reference.

Should you feel that this post is of use and or an accurate solution to the raised question, I kindly encourage you to mark it as such using the 'Mark as Solution', 'Kudos' andor ‘Me Too’ options.

Thank you for that direction.   

I ended up doing an IF (FFinishDate] = 1/1/1900, Empty String, Format Date and Time (Finish Date,MM/dd/yyyy))

 

Worked perfect!

Reply


Sidebar Buttons
Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
Terms & ConditionsCookie Settings