Solved

Unable to convert date time string to a Date time variable

  • 15 February 2019
  • 1 reply
  • 177 views
Lucky
Badge +3

I'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.

97i643264CF751CAC00.png

 

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.

 

icon

Best answer by jesse_mchargue 27 February 2019, 06:19

View original

1 reply

jesse_mchargue
Userlevel 6
Badge +12

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!

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings