Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello gurus!
I have an easy question which is driving me crazy!
The purpose is to load table AUFM from SAP. The field BUDAT is a date in following notation: 20/11/2012.
I want to load only the records from 2011 & 2012, therefore I use a where clause, but no records are loaded.
What is wrong in the script:
[AUFM]:
Load
[MEINS] as [Base Unit_MEINS],
text([MATNR]) as [Material_MATNR],
[SHKZG] as [Debit/Credit_SHKZG],
[WERKS] as [Plant_WERKS],
[AUFNR] as [Order_AUFNR],
[MENGE] as [Quantity_MENGE],
[BUDAT] as [Posting Date_BUDAT],
[BWART] as [Movement Type_BWART];
SQL Select MEINS MATNR SHKZG AUFNR WERKS MENGE BUDAT BWART from AUFM
where BUDAT > '31/12/2010'
;
Thank you for your help!
Hi Toby,
Make sure that your DateFormat in your Qlikview script matches the format of your Date field.
So in your cause I guess it should be:
SET DateFormat='D/M/YYYY';
or
SET DateFormat='DD/MM/YYYY';
Give it a try.
Good Luck,
Dennis.
Hi Toby,
Make sure that your DateFormat in your Qlikview script matches the format of your Date field.
So in your cause I guess it should be:
SET DateFormat='D/M/YYYY';
or
SET DateFormat='DD/MM/YYYY';
Give it a try.
Good Luck,
Dennis.
Hello Dennis!
Thank you for your help, this did the trick.