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

[jayesh_11]

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

2. 

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


Qlik Replicate 

[Chanty4u]

Hi

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.ht...?

[john_wang]

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.