You are viewing limited content. For full access, please sign in.

Question

Question

nvarchar to datetime

Workflow
Updated April 27, 2018
asked on April 27, 2018

Hi all,

 

I have a database with a field "date_facturation" with the Data type = datetime.

 

Using the workflow, i'm trying to populate this field with the Global value DateTime

 

I get an error about the type

 

How can I resolve this?

 

Thanks in advance.

Regards

0 0

Replies

replied on April 27, 2018

Hi Olivier

In Workflow, you may have to assign the Variable to a Token, then open the Token and click on Tags and chose only the DateTime Tag. Then use this token to update the DB Table

 

0 0
replied on April 27, 2018 • Show version history

Hi Steve

 

Thanks for your help.

I tried your solution but unsucess

 

 

 

 

Maybe because this is a french version?

How can I change it to a english version?

0 0
replied on April 27, 2018

What is the token value? I know this method works as I use it often. Maybe it is because of regional differences in date formatting MM/DD/YYYY vs DD/MM/YYYY? What happens if you construct the date token with a date token calculator?

0 0
replied on April 27, 2018

Hi John, the token value is "16/03/2018 08:01:50".

In my mind, you right ; the date formatting is the problem.

How can I construct the date token with a date token calculator?

I means, the date come from my database, so my first token is :

"16/03/2018 08:01:50"

I can't change this format.

0 0
replied on April 27, 2018 • Show version history

Open the token, right click on the variable and pick Token Editor in the drop down. Choose the Format option, in the field enter your new format, ie: dd/mm/yyyy hh:mm:ss 

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...