Comparing dates in select query.

[Former Member]

Hi Experts,

I need to select data from one table such that the date field of the table should be either today's date or earlier date.

How can I write such comparison statement in select query.

[Former Member]

Hi Experts,

I need to select data from one table such that the date field of the table should be either today's date or earlier date.

How can I write such comparison statement in select query.

[Former Member]

hi,

select * from <your_table>

where <date_field> <= sy-datum.

endselect .

regards,

burak