Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
OLEDB CONNECT32 TO ******
LOAD BRCODE,
DECDDT, //This is Timestamp in format ‘YYYY-MM-DD 00:00:00 000’
DECDTIME,
ORDNO,
IVNO,
IVDT,
SR, //Supplier
PNO,
PURQTY,
PURAMT,
CURR,
CREAID,
REFERENCE,
BRNO,
ORDTYPE;
SQL SELECT *
FROM PPMSDB1.dbo."PMS_PURCHASE";
1) How to write below SQL code in QlikView Script?
Select BRCODE, SR, SUM(PURAMT) From PMS_PURCHASE
Where (BRCODE = '123') and (DECDDT >= '2013-11-01')
Group By SR, BRCODE
Order By SUM(PURAMT) DESC
2) How can I convert DECDDT in ‘DD/MM/YYYY’
Try date(date#(left(DECDDT,10),'YYYY_MM_DD'),'DD/MM/YYYY')