Topic: Помогите пожалуйста добавить в поиск выборку за месяц.
Помогите пожалуйста добавить в поиск выборку за месяц. Для поиска использую SQL запрос.
SELECT
zurnal_cpu.id,
info_stanka.invent_nomer,
strftime('%d.%m.%Y', zurnal_cpu.data),
info_stanka.vnutr_nazv_cpu,
strftime('%H:%M', zurnal_cpu.vremia_ostanovki),
strftime('%H:%M', zurnal_cpu.vremia_sdaci),
zurnal_cpu.pricina_ostanovki,
zurnal_cpu.code_error,
zurnal_cpu.tekst_oshibki,
zurnal_cpu.vipolnenie_raboti,
smeni.smeni,
info_stanka.id_firmi_postavsiki,
info_stanka.id_tip_satanka,
info_stanka.nazv_stanka,
info_stanka.zavod_nomer
FROM
zurnal_cpu
LEFT OUTER JOIN info_stanka ON info_stanka.id=zurnal_cpu.id_info_stanka
LEFT OUTER JOIN smeni ON smeni.id=zurnal_cpu.id_smeni
WHERE
(CASE WHEN '{poisk}' <> '' THEN info_stanka.invent_nomer LIKE '%{poisk}%' or
info_stanka.vnutr_nazv_cpu LIKE '%{poisk}%' or
info_stanka.id_firmi_postavsiki LIKE '%{poisk}%' or
info_stanka.id_tip_satanka LIKE '%{poisk}%' or
info_stanka.nazv_stanka LIKE '%{poisk}%' or
info_stanka.zavod_nomer LIKE '%{poisk}%' or
zurnal_cpu.pricina_ostanovki LIKE '%{poisk}%' or
zurnal_cpu.code_error LIKE '%{poisk}%' or
zurnal_cpu.tekst_oshibki LIKE '%{poisk}%' or
zurnal_cpu.vipolnenie_raboti LIKE '%{poisk}%'
ELSE 1=1 END) AND
(CASE WHEN {DateTimePicker1} IS NOT NULL THEN date(zurnal_cpu.data) = date({DateTimePicker1}) ELSE 1=1 END) AND
(CASE WHEN {ComboBox1} <> -1 THEN zurnal_cpu.id_smeni = {ComboBox1} ELSE 1=1 END)
ORDER BY zurnal_cpu.data DESC