Skip to Content
0
Sep 18, 2012 at 02:39 PM

date operation in select statement

27 Views

Hi experts,

is there any way to compare the

month and date of table field with month and date of

sy-datum .

for Example

By using the select statement

select pernr nachn vorna from pa0002 into TABLE itab where gbdat = sy-datum.

the query retrieving results in which the gbdat equal to sy-datum( no records are fetched because for ex gbdat =19800918 and sydatum = 20120918 )

but i want to compare only the month and date of gbdat field with month and date of

sy-datum .

Regards

Prasad