Date Interface Input returs wrong date when run from Gallery

[SarahMB]

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

[tmashaba]

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