Hi team,
I’m using CSV file to trigger an event and in the file, there is a date data format. I follow Klaviyo instruction but when the data is uploaded to Klaviyo, there is still a mismatch in what displayed in the CSV and what recorded in Klaviyo.
Here’s the data I uploaded:
Here’s the time it shows in Klaviyo:
When uploading the file, I choose timezone as Asia/Ho_Chi_Minh.
I’m not sure what cause the issue and how to fix it so please help to investigate. Thank you so much!
Hi
So from what I can see, it appears that the timestamp is converting once you upload it. My theory is that the ‘CourseDate’ timestamp in your file is being identified as UTC time, and then it is converting that time to Asia/Ho_Chi_Minh time. Can you try mimicking the event timestamp formatting by adding a ‘+07:00’ to the end of the ‘CourseDate’ and ‘TicketOrderedDate’ timestamps?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.