Re: TZF -

Concerning the date filter - the following works for me, as I just
copied and pasted it from a successful project ( I dont even
like elegant, btw):

  d1,d2:string10;

  d1:=DateToStr(dtpStartDate.Date);      // from DateTimePicker   (dtp)
  d2:=DateToStr(dtpEndDate.Date);

  frmDM.DBF_Family.SetFilterTo(' entryDate<=CTOD("'+d2+'") .AND. (closeDate>
=CTOD("'+d1+'") .OR. entryDate>CloseDate)' );


Maybe this will help a little.

Bob Watson


____________________________________________________________________



In a message dated 2/5/2003 5:39:51 PM Eastern Standard Time, 
[email protected] writes:


> Ok Guys ... my original question/query again and a new one.
> 
> Extremely dissapointed at the lack of responses to my first question 
> which for some of you guys I thought would have been a breeze.
> 
> But here goes again.
> 
> Original Question First
> ------------------------
> Looking to filter a database on a date field. Is this possible. I'm 
> having trouble doing so.
> SFilter being a string input date in the format 18/10/1953
> UK/Ireland date format.
> Competitors.SetFilterTo('DATES == "'+CTOD(SFilter)+'"');
> This line above does not work no matter what way I type it.
> 
> Have tried the DTOC function as well as Marie suggested. No Good.
> 

==^================================================================
This email was sent to: [email protected]

EASY UNSUBSCRIBE click here: http://topica.com/u/?clvXPN.a5kvff.Z2NsZHQt
Or send an email to: [email protected]

TOPICA - Start your own email discussion group. FREE!
http://www.topica.com/partner/tag02/create/index2.html
==^================================================================