Regarding Date Function

[Sai_Mohan]

Hi all,

 I know this is the sql query. But i wanted to know how it works

1. CASE WHEN COS LIKE '%(%' THEN REPLACE(COS,SUBSTRING(COS, CHARINDEX('(', COS), CHARINDEX(')', COS)-CHARINDEX('(', COS)+2),'') ELSE COS END

This is from data-load editor in qliksense , Here duedate is column name and it contains some date values. how does this checksum works here.

2.Due-Date  =  DATEADD(day, ABS(CHECKSUM(NewId()))% 5, Due-Date);

Thanks.