Hi martina,

when i use your code

TEXT TO .SELECTCMD NOSHOW TEXTMERGE PRETEXT 15
			SELECT HDBK, Hid , HDOCNO, HAMOUNT,  HDOCDATE ,CREATEDBY,
			Createdon , hremint   FROM <<.TABLES>>
			WHERE hdocdate > {d '2010-01-31'}
      ENDTEXT

I have the error in attachment

>Hi Bernhart,
>
>You try use escape sequence...
>

>...where hdocdate > {d '2010-01-31'}
>...where hdocdatetime > {ts '2010-01-31 12:13:14'}
>

>
>MartinaJ
>
>>Hi all,
>>
>>please see attachment.
>>
>>

>>...where hdocdate > {^2010-01-31}...
>>

>>
>>Fails..
>>
>>what 's the good command ?
>>
>>Thank in advance
>>
>>
>>bernhart