Convert Date to Number by Peek

[flavioamcoutinho]

For i = $(numeroInicio) to $(numeroFim)
for j = 0 to $(nRows)

Let vData = Peek('Data',$(j));

Let vDataNum = num(Date#($(vData), 'DD-MM-YYYY'));


Trace $(vDataNum);

Next j;
Next i;

[SumitaKumari]

What is your question here ?

[marcus_sommer]

Your peek-statement missed the third parameter and of course must the used format-pattern be fitting to the data and the variable-content mustn't contain any comma.

Beside this such adjustments are usually better done within a load-statement and not with extra (nested) loops on the outside.

- Marcus