How can i change NULL with a date

[taz803]

i want to replace NULL with a date (if  DT_EVENT is null replace with 01/01/2023 ) 

how can i hundle it 

[Chanty4u]

Try this 

LOAD

    IF(ISNULL(DT_EVENT), Date#('01/01/2023', 'DD/MM/YYYY'), DT_EVENT) AS DT_EVENT

FROM YourTable;

[Vegar]

Id your field is numeric/date the you can use Alt(DT_EVENT,makedate(2023,1,1))

if its a string and you are on a recent Qlik Sense release.

Coalesce(DT_EVENT,makedate(2023,1,1))