Who can help me with this code ??

[Alex Duin]

My task is to get records out of a database with the date of today (CURDATE).
I think this ísn't a big problem i suppose ? Who can help me out.

This is wat i made of it:

SELECT GMSHPRM00.HPRBEGDAT, GMSHPRM00.HPRENDDAT, GMSHPRM00.HPRADMNUM
FROM NLGEMHKS.SASGMS.GMSHPRM00 GMSHPRM00
WHERE GMSHPRM00.HPRBEGDAT AND GMSHPRM00.HPRENDDAT = CURDATE()

This query doensn't work however, what can i do about my problem ? I get: operands not compatible.

I see with the currentdate in my database that i've got 5 records, but i only want that 5 records for my output and not the rest of older fields.

I really appreciated if someone has got a solution.

Best regards,
Alex Duin