Workflow with date format issues between two computers

[GustavoTR]

Hi all,

We have the following issue with a clients Workflow. We built the WF in our equipment and its runs well, it also gave us the expected results, but when we sent it to our client to do the UAT cases, we had an unexpected result here.

For example: When we expected the date "06/01/2023" we got a "20/01/2006".

Context: We have as a Input file a csv Output file generated by Alteryx. The problem is with this file, because when the app runs another csv file, Datetime formats are ok. Another thing to say it is that we have our computers with OS in English, but as we know the clients has his OS in Spanish, that could be a problem? Considering this, we configure the next formula to convert the date field to string 

DateTimeFormat([Fecha de documento],"%Y-%m-%d","Spanish")

I'm attaching the output files generated by the client and mine.

Hope so could help us with some thoughts.

Kind regards.

[DavidSta]

Hi @GustavoTR,

most likely the issue is that your client is opening the CSV with Excel and Excel applies some formatting to the data.

Otherwise I never experienced some issues like you said.

They should try opening the file with Notepad++ or similar to check the created file, I would expect it's ok.

If not, I would recommend you share a sample workflow, so that the community can check with you.

Best regards,

David

[GustavoTR]

Hi David, 

I tried to open the client file on my laptop using Notepad++, but I could see the same issue.

I am sharing with you a folder where I upload a sample from this workflow. Let me know if you can access to the archive.  

https://trten-my.sharepoint.com/:f:/g/personal/gustavo_rodriguez_thomsonreuters_com/EoX6k8zf4elFghNO...

Regards.

[DavidSta]

Hi @GustavoTR,

I can't access your Sharepoint. But regarding the file I am not fully sure - I would not trust it directly to be not manipulated by Excel ;-)

On the other hand it would make more sense when we could take a look to the Workflow itself.

You can attach files in the community as well while replying.

Best regards,

David

[GustavoTR]

Ok David, I have had some problems trying to upload the wf to this chat, we have some restrictions here to share some sensitive information. 

Let me try another way.

Thanks.