Replacing default value to user defined value

[suvbin]

How to replace the default value  00000000   to  some date value like  01/02/2020.   I have few date columns,  in the source side the default value is kept as  0000000  to them. if i want to change the the default value to some date value, then how to do it using expression builder. 

[AlexeySosnovskih · Accepted solution]

replace($name,'00000000',strftime('%Y/%m/%d','now'))

[suvbin]

Thank you for the update.   if i want to put only this value  "01/02/1900" then ...   ? And also if i want to  replace more than on e column ...  ? how to do that 

replace($name,'00000000',strftime('%Y/%m/%d','now'))   --  > this will replace with the current date ?

[Madhavi_Konda · Accepted solution]

case when $DATE_TEST='00000000' then '01/01/2020' else $DATE_TEST end  you can use this expression as well.

And also as Alexey suggested replace($DATE_TEST,'00000000','01/01/2020')

Thanks,

Madhavi

[suvbin]

 Ok for each column i need to open expression builder seperately and then give this transformation.

[Madhavi_Konda]

Yes.

[suvbin]

Thank you Alexey , Thank you Madhavi.