|
<< Click to Display Table of Contents >> Navigation: Telegram > 2023 > 08 > 10 > Telegram_2023-08-10T00 |
2023-08-10T00:32:49
hi
2023-08-10T00:33:26
I have problem with search data use date format
2023-08-10T00:35:24
it was running ok , 2022 but when we get in 2023 start show error
2023-08-10T00:36:36
search can not recognize year only month and days
2023-08-10T00:37:18
show data of month one 2022 plus data of month one 2023
2023-08-10T00:37:45
i am using datform mm/dd/yyyy
2023-08-10T00:37:55
date format
2023-08-10T00:38:18
thanks for your advice
2023-08-10T00:39:20
I am save date in mysql tables as strings not date
2023-08-10T00:41:14
performance will be fine
2023-08-10T00:42:22
Hi type: mention_name saleh user_id: 1977652340 I'm not sure what kind of \search\ you are doing. Show the code
2023-08-10T00:42:48
ok
2023-08-10T00:44:41
else
if (end_edt.Text = '') or (start_edt.Text= '' ) then begin
WebApplication.ShowNotification ('Date not Seelected');
exit
end
else
UserSession.DM.Report_1.open;
with UserSession.DM.Report_1 do
begin
Filtered:=false;
Filter:='arr_date >= '+QuotedStr(start_edt.text) + 'and arr_date <= '+QuotedStr(end_edt.text) +'and clinic_name = '+QuotedStr(doctor_box.Text);
FilterOptions:=[foCaseInsensitive];
Filtered:=True;
houes_72_grid.Visible := false;
clinic_Grid1.Visible:= true;
rec_count_lbl.Caption := inttostr(recordCount);
clinic_Grid1.DataSource:=UserSession.DM.Report_1_s;
end;
end;
2023-08-10T00:56:13
Exit lacks ;
2023-08-10T00:57:22
Insert a space before 'and after both quotedstr functions