Trim DateTime from SharePoint and embed in Loop for Each

Hi @mjliu 

I assume after you Loop through each Item and Format the Date then you want to build a HTML text for each Date ...is that right?

or you can simply add ALL the format dates into one Text variable with each Date separated by semicolon ; so that you then RegEx it after the loop using the “Split” operation .

it would be great to see ( a screenshot ) of the “Create Text String” action what are you trying to compile as a text?

Thanks,Majid

Hi Majid, pls see below

I was trying to create another column in SharePoint to convert date to text (calculated column) but not able to find this column in Loop for each to build the message. is it not supported at Nintex? I am able to see the column in Query a list action.

Hi @mjliu 

Thanks for your reply, 

does the Format Date action return  the Date format as :YYYY-MM-DD as expected? is that what you wanted to return? or it return different text value for the “Project Exp Completion Date” ?

Thanks,Majid

Thanks Majid.

The format is fine, but i am getting duplicate dates in the return, so i think it is related with loop for each.

Also am i not able to extract calculated value field from SP?

It seems so…

Hi @mjliu 

i see...could be that because you might have a nested loop? do you have more than one loop in the design?

please send us a screenshot of the action : “Create Msg for tracking Email” ?

Thanks,Majid

Thanks, i do not think Format date to string works in this case (not sure why) but Apply a regular expression would work. All good now.

Hi @mjliu 

Great to hear that you manage to find a solution!

The Format date to string requires a Date value. It works great
I usually convert the “Current Date and Time” to into a string for humanizing DateTime output

With the 12-May NAC update, you (or your NAC admin) should be able to set the correct date format.