Date Import Confusion

General
1

I have a CSV file with two columns containing date values:

image

I import these values into two columns in a table. DateFromFolderName goes into a STRING column. DateTimeSubmitted goes into a DATETIME column. The result is:

image
image720×438 23.4 KB

Notice that the DATETIME column is one day behind the STRING column and sometimes with time 19:00 and sometimes with time 20:00. I deduce that the problem is with time zone. Am I correct? Backendless is adjusting the DATETIME value according to the difference between my time zone and GMT? Is there a way to prevent this or adjust for it other than writing some code?

Thanks.

2

Hi there @Howard_Jacobson,

Make sure that the “Dates in UTC” checkbox is unselected if you need to display your local time. Otherwise to display the UTC the checkbox should be selected.

Regards,
Marina