topic Comparing dates in select query. in Application Development and Automation Discussions

Comparing dates in select query.

Former Member — Wed, 07 May 2008 06:24:23 GMT

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 — Wed, 07 May 2008 07:01:12 GMT

hi,

select * from <your_table>

where <date_field> <= sy-datum.

endselect .

regards,

burak