I have a CSV file with dated transactions that I want to upload via the CSV import. The problem is that the system applies some sort of timezone changing what gets stored in the database.
if the csv has 2024-02-07 then that's what I would like recorded in the database.
I am using the Jdate element set to the local time zone
- CSV Import Format = Normal
- J! time zone is set to Melbourne (my local timezone)
- Hosting server is set to Melbourne
- database server is also set to Melbourne
The date 2024-02-07 gets stored as 2024-02-06 02:00:00. I would like it to be stored as 2024-02-07 or 2024-02-07 00:00:00
What setting do I need to use to make sure the date value is stored without being offset by some timezone.
if the csv has 2024-02-07 then that's what I would like recorded in the database.
I am using the Jdate element set to the local time zone
- CSV Import Format = Normal
- J! time zone is set to Melbourne (my local timezone)
- Hosting server is set to Melbourne
- database server is also set to Melbourne
The date 2024-02-07 gets stored as 2024-02-06 02:00:00. I would like it to be stored as 2024-02-07 or 2024-02-07 00:00:00
What setting do I need to use to make sure the date value is stored without being offset by some timezone.