Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
How can i change the date in DL_Max?
See attached.
SET DateFormat='DD.MM.YYYY';
s:
LOAD DL_Max FROM DL_EVTIMEFORBRUKHIST.qvd (qvd);
let v=Peek('DL_Max');
s2:
NoConcatenate load date(num('$(v)')+1) as DL_Max AutoGenerate 1;
STORE s2 into DL_EVTIMEFORBRUKHIST.qvd (qvd);
i need the date to be 30.11.2014
s2:
load
date(makedate(2014,11,30)) as DL_Max AutoGenerate 1;
STORE s2 into DL_EVTIMEFORBRUKHIST.qvd (qvd);
Script:
LOAD DL_Max
FROM
(qvd);
let v=Peek('DL_Max');
s2:
load
date(makedate(2014,11,30)) as DL_Max AutoGenerate 1;
STORE DL_EVTIMEFORBRUKHIST into DL_EVTIMEFORBRUKHIST.qvd (qvd);
_____________________
New problem:
Now todays date appears AND 30.11.2014.. any suggestions?
Thanks for the help so far.
Hi
try adding NoConcatenate.
LOAD DL_Max
FROM
(qvd);
let v=Peek('DL_Max');
DL_EVTIMEFORBRUKHIST:
NoConcatenate
load
date(makedate(2014,11,30)) as DL_Max AutoGenerate 1;
STORE DL_EVTIMEFORBRUKHIST into DL_EVTIMEFORBRUKHIST.qvd (qvd);
when i add NoConcatenate the date 30.11.2015 disappears.
I am not sure why you do the first load, anyway give that table a name (other than DL_EVTIMEFORBRUKHIST):
a_named_table:
LOAD DL_Max
FROM
(qvd);
let v=Peek('DL_Max');
DL_EVTIMEFORBRUKHIST:
NoConcatenate
load
date(makedate(2014,11,30)) as DL_Max AutoGenerate 1;
STORE DL_EVTIMEFORBRUKHIST into DL_EVTIMEFORBRUKHIST.qvd (qvd);