Peek function creating issue for Date

[mhmmd_srf]

Hi All,

I want to determine the max date for my incremental load. But when I am using Peek function the variable is showing wrong format.

in source date is in below format:

My Script is:

Last_Date:

LOAD

Date (max(action_date$)) as MaxActionDate

FROM

(qvd);

let vMaxDate = Date(peek('MaxActionDate',0,'Last_Date'));

MaxActionDate is showing in right format:

But Variable vMaxDate is showing in wrong format:

Could you please help to get this correct.

Thanks,

Sarif

[mhmmd_srf]

okk

this is very tricky.. do u have any good doc on the variable. Like when we will use Set and when Let. When we will use $ and when not.

[sunny_talwar]

For set and let

QlikView Addict: SET vs. LET

Dollar sign expansion

The Magic of Dollar Expansions‌

Variable

The Magic of Variables

Equal sign

The Little Equals Sign

[mhmmd_srf]

Thanks a lot Sunny... you are always very helpful.