Query with Current Date

[jorame]

Hi guys,

I'm trying to create a QMQRY but I missing one of the field selection which is the date. This is my SQL:

SELECT
ALL T01.CDCASN, T01.CDAREA, T01.CDSTYL, T01.CDCOLR, T01.CDSDIM,
T01.CDPAKU
FROM WM242BASD/CDCART00 T01,
WM242BASD/CHCART00 T02
WHERE CDCASN = CHCASN
AND( CDCASN = CHCASN
AND CHSTAT = '10'
AND CDDCR = 'CURRENT_DATE')
ORDER BY T01.CDCASN ASC, T01.CDAREA ASC

How can I pull date where field CDDCR (Created Date) is equal to current date? Any help would be really appreciated.

[kitvb1]

You are testing the contents of CDDCR being equal to 'CURRENT_DATE' --> note the apostrophes.

[Denny]

Current_date should NOT be in quotes.