topic Re: Date format issue in DemandTools

Date format issue

SM — Wed, 08 Feb 2023 09:22:37 GMT

Hi, we have recently started using Demand Tools and I am having a problem uploading data with the correct dates. I uploaded approximately 9000 records, each with 4 or 5 date fields and a large number of them uploaded as the next day. Not all of them did, and there didn't seem to be a pattern, some records had a mix of the correct date and the next day.

So I put the dates in this format '2021-01-28T00:00:00.00Z' and updated them using Demand Tools, only this time they updated as the day previous. How do I format the upload to get the exact date I need?

Re: Date format issue

DanW_Validity — Wed, 08 Feb 2023 20:42:28 GMT

Hello @SM

This is something that I am currently iinvestigating on a different post https://mycommunity.validity.com/t5/demandtools/date-format/td-p/198

What I have found in my investigating so far is the dates are the previous day in Salesforce is when the machine's timezone is east of GMT.

When my machine's timezone was set to (UTC +01:00) the dates were being imported a day behind. When I changed the timezone to (UTC +00:00) the dates were being imported the same date as what my file had, regardless of the date format I used.

Is your machine's timezone set to UTC +01:00 or higher? Example UTC +05:00

Dan

Re: Date format issue

SM — Thu, 09 Feb 2023 08:05:13 GMT

Hi Dan. My timezone is set to UTC+00:00. It's also not consistent across all dates, some were uploaded with the correct date and some were not.

Re: Date format issue

SM — Fri, 10 Feb 2023 11:51:35 GMT

I've updated to the latest version of Deman Tools and still can't consistently upload correct date fields, it is very odd

Re: Date format issue

SM — Fri, 10 Feb 2023 13:47:58 GMT

Re: Date format issue

DanW_Validity — Fri, 10 Feb 2023 15:54:04 GMT

Thank you for this additional information @SM we are currently investigating this.

I will post a reply when I have more information.

Dan

Re: Date format issue

AnthonyValidity — Mon, 13 Feb 2023 16:50:36 GMT

Hi @SM ,

I looked over your account and noticed you have Ticket #142031 open with Support. I think the best course of action is to continue working with them off of the ticket. I'm going to circle back with @DanW_Validity as well.

Regards,

Anthony
Customer Success Manager

Re: Date format issue

SM — Tue, 14 Feb 2023 08:26:50 GMT

Thank you!