Peek returns null value

[#1]

Hi,

I'm trying to use peek , but returns null. Code is like this:

DATES1:

LOAD

DATE

.....

LET varMDate = Num(Peek(DATE, 0, DATES1))

.....

Any clue?

-Arun

[#2]

I guess the code should be

LET varMDate = Num(Peek('DATE', 0, 'DATES1'))

[#3]

Amit, no luck.

-Arun

[#4]

Arun, are you sure that the value is not null in source data? Try putting some other number instead of 0 in that code and see if it still gives null.

Thanks

Amit

[#5]

Amit,

Yes, I was trying that. and for some other random number is is returning value. Now I'm out of the dark.

Thanks Bud.

-Arun