Hi, I have an Alteryx app that takes several interface inputs, including two date inputs. The two date inputs don't return the correct dates when running the workflow from the gallery. They work fine when running from Alteryx. For example, if I select 1st April 2016, it will return 31st April 2016, which isn't even a valid date. If I input 3rd August 2016, it returns 2nd August 2016. Here are some tests I did:
Selected value | Result value |
31/05/2017 | 30/05/2017 |
01/05/2017 | 30/05/2017 |
16/05/2017 | 15/05/2017 |
01/04/2017 | 31/04/2017 |
01/01/2017 | 01/01/2017 |
01/11/2016 | 01/11/2016 |
30/11/2016 | 30/11/2016 |
22/06/2016 | 21/06/2016 |
I have attached a more basic version of my workflow, which suffers from the same problem.
I initially thought it was a server issue, but the 31st April date result threw me a bit. Can anyone help me with this please?
Thanks,
Sarah
Solved! Go to Solution.
I am using Alteryx 2021.1.3.22649 and experiencing something similar. I am uploading my data to a table in snowflake. using the browse tool I can see the right time in Alteryx. but once uploaded, the dates in one specific row are minus one day.
i have changed formats of the date but nothing solves it.
UPDATE
i found out that it seems to be a timeshift for me