Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
which version QV you are using
for me its showing
do one thing, paste my script in your app.
check these varibles how its showing (variable name changed) vRuntime,vRuntime1,vnum
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
LET vRuntime=Date(num(now()));
let vRuntime1=now();
let vnum=num(now());
annual:
LOAD DATE,
MONTH,
YEAR
FROM
D:\Qlikview\source\Data.xlsx
(ooxml, embedded labels, table is tbl_Date);
still same, but the difference is runtime 2 shows old time whereas runtime shows current time.
still same, but the difference is runtime 2 shows old time whereas runtime shows current time.
Which Version you are using 11.2 or 12
please post your script and your sample app
i have qlikview 11, btw leave it.
thank you so much.
Seems Question answered, I am not sure where i need to reply
now() gives you the current system's date and time &
num(now()) converts the current date and time into a number.