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?
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
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.
Customer Success Manager