topic We have set Data format to CSV, but we are seeing data loss and date is missing in Qlik Replicate

We have set Data format to CSV, but we are seeing data loss and date is missing

jayesh_11 — Tue, 15 Sep 2026 08:10:46 GMT

So we trying to load data in s3 bucket in CSV format but i can see dates are not getting populated in CSV soo i have applied global rule but than it is changing the date

1 transformation rule
Transformation

Convert data type

Transformation Scope

Schema name is like: % Table name is like: % Column name is like: % Data type is: DATE

Transformation Action

Set target data type to: STRING(40) Set target sub data type to: Regular

Convert data type

Transformation Scope

Schema name is like: % Table name is like: % Column name is like: % Data type is: DATETIME

Transformation Action

Set target data type to: STRING(40) Set target sub data type to: Regular

while applying this we are getting date like this
0003-00-00 00:96:66.000000

Re: We have set Data format to CSV, but we are seeing data loss and date is missing

Chanty4u — Tue, 15 Sep 2026 19:07:51 GMT

Yes — the issue is most likely related to how the DATE/DATETIME value is being converted before the CSV target writes it. The value 0003-00-00 00:96:66.000000 is clearly not a valid date/time, so I would not recommend simply converting DATE/DATETIME → STRING globally as the first fix.

Qlik Replicate internally converts source values to its own data types before writing to the target. DATE and DATETIME have specific expected formats

Check below link

https://help.qlik.com/en-US/replicate/May2025/Content/Replicate/Main/Endpoints/att_rep_data_types.htm?

Re: We have set Data format to CSV, but we are seeing data loss and date is missing

john_wang — Sun, 20 Sep 2026 01:21:31 GMT

Hello @jayesh_11 ,

Could you please share the source database or endpoint type you are using? We'd like to verify the behavior and confirm it for you.

Regards,

John.