Qlik Expression Clarification

[Purushothaman]

Hi Experts,

What does the below syntax does?

Where trunc(LAST_UPD_D) > trunc(to_date('$(vDate)','YYYY-MM-DD'));

Please help!

Many Thanks!

[anat · Accepted solution]

Trunc function in SQL ,will take only date part from the source field.

The TRUNC (date) function returns date with the time portion of the day truncated to the unit specified by the format model fmt.

in qlik you can use floor function .