Analytic App date selector - Incorrect dates picked up

Hello,

I have an issue with a workflow published to our Alteryx Gallery. It's set up to take FROM and TO dates as parameters but for some reason when I run it from the gallery, it minuses 1 day from each of the dates.

I've stripped down the workflow and attached it. In the example below, I selected May 15th to May 19th. When I ran the flow, it emails me the selected dates, which came back as May 14th to May 18th.

AnalyticAppDates.yxwz

Apps

Accepted answers

ChristianR

Hi All

Thanks for the outputs and feedback. I can confirm we are able to replicate this issue on our latest Server version and we will be escalating internally to find the root cause. As a workaround please use Chrome instead of IE. However, if you must use IE from your client then you can change your Date Time Zone to match the Server Time Zone and this should generate the correct results.

All comments

MarqueeCrew

I am not near a computer, but offer this suggestion:

Check the date fields and make sure that they are not datetimes.

Cheers,
Mark

Kieran

On the example I attached, its using a text input with the actions attached to that. So everything is coming through as strings.

Thanks though...

SeanAdams

Hey @Kieran

Are your user and your server in a different timezones? Reason for asking is that if the date-time tool is storing this in UTC format under the covers then this would make sense and would be accurate (in a bizarre kind of way) because if it's doing a string convert under the covers from a date-time with UTC information then it will push it into the next day.

I've done a different version (attached) which pumps it directly into a date (no time). Not sure if this will fix it. What you can do to check your server time if you don't have access to it is just add a dateTimeNow function and put this in the output.

Updated version with all these changes attached.

Let me know if this gets you to a solution?

AnalyticAppDates.yxwz

Kieran

The workflow you attached was created in version 11, we're still running version 10.6 so I cant open it.

I'm in Ireland (GMT), the server is in the States, central time. It shouldn't effect the date that comes back. Central time is still on the same date as me when I run the workflow...

SeanAdams

I've changed the version in the workflow and reattached (not sure if you know, but it's relatively easy to change the version just by opening it up in Notepad.

as part of this flow - I've added a check on the server date & time so that you can see the datetime on the server to see if it's offset in some way.

Cheers Kieran

Sean

AnalyticAppDates.yxwz

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335