topic SAP Where DateField > '01-01-2011' Not Working in QlikView

SAP Where DateField > '01-01-2011' Not Working

Sokkorn — Tue, 11 Jan 2011 04:45:48 GMT

Dear All,

Please see the load script below:

[ConditionDate]:

LOAD

ERDAT

AS [F1],

DATE

(ERDAT,'dd.MMM.yyyy') AS [F2],

NUM(ERDAT) AS [F3];

SELECT

WHERE

ERDAT >= '01-01-2011';

When finished execute script I got all date data. Mean that where condition not working.

Note: I try to get data from SQL Database it ok with condition above, but I face the problem when try with SAP.

Please advice me to do this.

Thanks in advance!

ERDAT FROM VBAK

SAP Where DateField > '01-01-2011' Not Working

Tue, 11 Jan 2011 04:51:59 GMT

In SAP the date columns wont be format of date mostly it will be like this '!11122010' so pull that in same way then take of character out make the date format in this way

DATE(LEFT([Docdate],2)&'/'&MID([Docdate],4,2)&'/'&RIGHT([Docdate],4),'DD/MM/YYYY') as Docdate.

SAP Where DateField > '01-01-2011' Not Working

maneshkhottcpl — Tue, 11 Jan 2011 04:57:19 GMT

first check ur ERDAT formate

if it is in datetime formate then ok

else

use date(makedate(left(ERDAT,4),mid(ERDAT,5,2),right(ERDAT,2)),'DD-MM-YYYY')

SAP Where DateField > '01-01-2011' Not Working

Sokkorn — Tue, 11 Jan 2011 05:05:36 GMT

Thanks for your quick reply.

I have list down the field data and see in format (dd-MM-yyyy). Ex. 01-01-2010, 01-01-2011, 01-02-2011

When use where ERDAT > '01-01-2011', like example above it should be return 01-01-2011, 01-02-2011

but after finished load, I got all data (01-01-2010, 01-01-2011, 01-02-2011)

What I do wrong with this?

Please help.

SAP Where DateField > '01-01-2011' Not Working

maneshkhottcpl — Tue, 11 Jan 2011 05:09:53 GMT

Hi,

use where date(makedate(right(ERDAT,4),mid(ERDAT,4,2),left(ERDAT,2)),'DD-MM-YYYY') > '01-01-2011'

for any issue u can post me.

SAP Where DateField > '01-01-2011' Not Working

Tue, 11 Jan 2011 05:13:23 GMT

debug ur data and send the application with 10 records...

SAP Where DateField > '01-01-2011' Not Working

Tue, 11 Jan 2011 06:24:58 GMT

In SAP the date format is YYYYMMDD. You should be using the ERDAT>='YYYYMMDD'.

SAP Where DateField > '01-01-2011' Not Working

Sokkorn — Tue, 11 Jan 2011 06:54:18 GMT

This one is correct for me ERDAT >'YYYYMMDD'

Many thank everybody!