Filter a date from and through

[heydyrtt]

Hello;

Have a table with a field called date_mail, on my form I have two datetimepickers one is named fromdate and the other todate. On exit of todate I want it show in the grid the data of the dates that were choosen. I can do this with codebase, but I'm changing over to SQL99 and having problems getting it to SQL format. Any help would be appreciated, below is the codebase code.

FilterStr = "";
DM->tblResident->Filtered = true;
FilterStr = "(DTOS(DATE_MAIL) >= '" + DTOS(fromdate->Date) + "') .AND. " +
&quot;(DTOS(DATE_MAIL) <= '&quot; + DTOS(todate->Date) + &quot;')&quot;;
if(jFilter.IsEmpty() == false && FilterStr.Length() < 60) {
if(jFilter.Pos(&quot;.AND.&quot == true) {
DM->tblResident->Filter = FilterStr + jFilter;
}
else {
DM->tblResident->Filter = FilterStr + &quot; .AND. &quot; + jFilter;
}
}
else {
DM->tblResident->Filter = FilterStr;


Thanks

heydyrtt

 

[heydyrtt]

I figured it out here it is if anyone needs it. This is for a flashfiler database.

TDateTime BeginDt,EndDt;
String BeginStr,EndStr;

BeginDt = fromdate->Date;
EndDt = todate->Date;
BeginStr = BeginDt.FormatString(&quot;yyyy-mm-dd&quot;
BeginStr += &quot; 00:00:00&quot;;
EndStr = EndDt.FormatString(&quot;yyyy-mm-dd&quot;
EndStr += &quot; 00:00:00&quot;;

DM->ReasonQuery->SQL->Clear();
DM->ReasonQuery->SQL->Add(&quot;SELECT date_mail,res_lname,res_fname,reason&quot;
DM->ReasonQuery->SQL->Add(&quot; FROM resident &quot;
DM->ReasonQuery->SQL->Add(&quot;WHERE date_mail&quot;
DM->ReasonQuery->SQL->Add(&quot; >= timestamp '&quot;+BeginStr+&quot;' AND &quot;
DM->ReasonQuery->SQL->Add(&quot;date_mail <= timestamp '&quot;+EndStr+&quot;'&quot;
DM->ReasonQuery->SQL->Add(&quot; ORDER BY date_mail&quot;
DM->ReasonQuery->Open();
DM->ReasonQuery->Close();