Question reg. 'Select' statement on date

[Former Member]

I want to select records from a database table based on a certain date if it is initial.

When I wrote "select so and so where date is initial' it gives me syntax error "The operator IS can only be used in "f is NULL" or "f is NOT NULL"

Please help to correct this error and how to choose the records based on that date is initial.

Thanks.

Message was edited by:

Krishen

[Former Member]

hi Krishen,

please try the following logic:

select * from <table name> where <date field> = space.

or if the above statement does not work, try the following code:

select * from <table name> where <date field> = '00000000'.

hope this helps,

Sajan Joseph.

[Former Member]

Something like:

SELECT * FROM bkpf
  WHERE aedat = '00000000'.

Rob

[Former Member]

hi

this is the code to select the record from sflight table with date equal to what you have given in the screen

copy the code and alter the table name what you want

DATA: WA_SPFLI TYPE SFLIGHT.

PARAMETERS: P_DATE TYPE sflight-fldate.

SELECT * FROM SFLIGHT INTO CORRESPONDING FIELDS OF WA_SPFLI WHERE

FLDATE = P_DATE .

WRITE : / wa_spfli-fldate,

wa_spfli-planetype.

ENDSELECT.

hope this will help you

with regards

Vinayaka