Cut the SAP table VBRK by dates

[#1]

Hello,

I'm trying to cut the SAP table VBRK by dates.

I would like to download data from the table when the fields ERDAT and AEDAT = yesterday.

I tried "Makedate" function and other functions without success.

Does anyone have experience on?

Thank you

Elad

[suniljain]

declare one variable name is yedterday

and assign date that is today()-1,

and pls use that variable in where condition like

where erdat = Yesterday and AEDAT = Yesterday

[#3]

Hello Sunil,

Thank for your answer,

The problem that is QV not difined the EADAT filed as a date field.

Elad

[cotiso_hanganu]

than use NUM() function to make it a number

[cotiso_hanganu]

Most likely you are trying to use makedate function (which is a QlikView function, available only in LOAD statements) in a SQL SELECT statement which should use the respective SQL syntax.
More advice if you show us some script sample.

[suniljain]

right now I am unable to log in SAP so can you tell me it is in which format.