+3I'm importing an RSS feed into a list using Nintex workflow. The date format in feed item is "Fri, 16 Dec 2018 05:50:06 EST". i want to convert this date into a date time field and insert into the column.
I used Convert value action for this. the configuration is as in below screenshot.
I was getting error "String was not recognized as a valid DateTime.". I tried different combinations, but its giving error. Could some one help me with the format I should use for acheiving this.
Best answer by jesse_mchargue
Hello -
A few things to consider, be sure that the day of the week ("ddd") is accurate with the acutal date you are providing. The example you have, 16 May 2015 is actually Saturday, not Friday. Just a heads up, that caused some failures as well :)
Alas, here is what you need:
ddd, dd MMMM yyyy hh:mm:ss
You may need to adjust your time after you save the new date depending on your tenant. I believe that it defaults the time conversion to UTC+0 so for me, I see Fri, 15 May 2015 05:50:06 as 5/14/2015 10:50:06 PM in my tenant.
Hope this helps!
+12Hello -
A few things to consider, be sure that the day of the week ("ddd") is accurate with the acutal date you are providing. The example you have, 16 May 2015 is actually Saturday, not Friday. Just a heads up, that caused some failures as well :)
Alas, here is what you need:
ddd, dd MMMM yyyy hh:mm:ss
You may need to adjust your time after you save the new date depending on your tenant. I believe that it defaults the time conversion to UTC+0 so for me, I see Fri, 15 May 2015 05:50:06 as 5/14/2015 10:50:06 PM in my tenant.
Hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
