TIMESTAMP is not working

[Anonymous]

I am loading date from QVD which is holding a single value . Below is the script that i am using

abc :

LOAD MaxUpdatedDate

FROM

(qvd);

let p=FieldValue('MaxUpdatedDate',1); // It is coming fine

LET vMyVariable  = TIMESTAMP(FieldValue('MaxUpdatedDate',1),'DD-MMM-YYYY hh:mm:ss.fff'); // having issue with this

I am not able to see vMyVariable on screen . Please help me

[YoussefBelloum]

Hi,

what is the format of your MaxUpdatedDate field ?

[jonvitale]

If you use the debugger in the load script and place a breakpoint after the LET vMyVariable statement, what do you wee there?

[Anonymous]

Hi ,

This is the format  "19-Mar-2018 17:47:41.933"

[Anonymous]

Hi ,

vMyVariable <NULL>

[YoussefBelloum]

so here you just want to get the minimum timestamp value loaded on the abc table ?

[Anonymous]

i want max value . Also below code is not working

abc :

LOAD

max(MaxUpdatedDate)

FROM

(qvd);

max  function is not working too

[vishsaggi]

Try this? And FieldValue() Function works only on Distinct values of the Field.

LET vMyVariable  = TIMESTAMP(TIMESTAMP#(FieldValue('MaxUpdatedDate',1),'DD-MMM-YYYY hh:mm:ss.fff'));

[YoussefBelloum]

EDITED

try this code:

abc :

LOAD Timestamp(Timestamp#(MaxUpdatedDate,'DD-MMM-YYYY hh:mm:ss.fff''),'DD-MMM-YYYY hh:mm:ss.fff') as MaxUpdatedDate

FROM

(qvd);

LET vMyVariable = Peek('MaxUpdatedDate',0, 'abc');

TRACE $(vMyVariable );

LET ME KNOW

[Anonymous]

hi ,

Its working now . Thanks a ton