How to use control \Convert Value\" to convert Single Line variable to Date variable"

  • 28 October 2016
  • 2 replies
  • 0 views

Badge +6

By using "QueryXML" I fetched Date in Single Line workflow variable viz. "Expiry Date SL_WV".  (I fetched data in single line workflow variable because Query XML do not allow to store result in date variable).  Then I tried to use "Convert value" to convert "Expiry Date SL_WV" and store in Date variable (Expiry Date_WV).  I tried most of the combinations given in other articles in the community articles.  However, I am not able to convert into Date variable.  Can any body help me to solve this issue.  Giving below screen shot of "Convert value".

193686_pastedImage_1.png

Thanks

Sunil


2 replies

Userlevel 6
Badge +16

Try the following:

Input:Expiry Date SL_WV

Store result in:Expiry Date_WV

Date format:MM/dd/yyyy

Culture:en-US

Badge +6

Thanks a lot Fernando,

In fact I got the solution just after placing query on community.  The difference is only input variable.  I used Input as : 

fn-Substring(Expiry Date SL_WV,0,10) and Culture : blank.  It gave me correct result as :

Expiry Date SL_WV : 10/29/2016 00:00:00
Expiry Date_WV : 29/10/2016 12:00 AM

I still tried with the options given by you and it gave an error.

Giving below screen shot of the Convert Value, it may help somebody.

193697_pastedImage_7.png

 

Thanks once again. Cheers happy.png

Sunil

Reply