tnx craig
k
>DTOC() will convert to mm/dd/yyyy. Not what you want. Try DTOS()
>
>>thanks tore. in fact I was sorting on a field that showed dtoc(date) so I was having some difficulty getting it work. Any idea on how to set that up?
>>At any rate I di have a date field in the records so I applied your solution without any issues. thanks a lot.
>>k
>>
>>>>how would I display all records before a specific date.
>>>>I have a field called kdate which displays when a record was created
>>>>I need to call all records before April 2013.
>>>>
>>>>thanks
>>>>k
>>>
>>>
.. for kdate < date(2013,4,1)
>>>or
>>>Set filter to kdate < date(2013,4,1)