Conversion numeric to date with Replicate

[EasyThomas]

Hi,

I try to build a replicate task with db2i as a a source and SQLServer as a target.

I try to convert a numeric colum from my source in a date column on my target

The coulmn from my source looks like that '20210615'

The implicite conversion didn't work and there is no function for conversion

Any idea ?

Regards,

[sunny_talwar]

Try this

=Date(Date#('20210615', 'YYYYMMDD'))

[EasyThomas · Accepted solution]

Hi,

I post the answer if anybody need it in the future

Ther is no date format in SQLite so i used the implicit conversion with the good format for SQL Server

substr('20210615',1,4)||'-'||substr('20210615',5,2)||'-'||substr('20210615',7)

[suvbin]

with out using Substring how to do it.

[john_wang]

Hello @suvbin ,

May we know more information to understand the request well?

1- source/target sides database type

2- source/target sides column type

3- a sample of the data in source and what's expected results in target

Regards,

John.

[Steve_Nguyen]

try this article :

https://community.qlik.com/t5/Qlik-Replicate/Using-DATE-TIME-functions-in-Qlik-Replicate-to-translat...