1 (edited by borisavljevic 2021-08-25 22:42:59)

Topic: [SOLVED] How to include date from DateTimePicker in SQL Query?

Hi,

I'm having problems trying to make my own quarry button. What I'm trying to do is to include date from component DateTimePicker into my own query.

SELECT DISTINCT "sirovine"."naziv" as "sirovine.naziv" ,(SELECT total(kolicina) FROM sirovine_izlaz WHERE sirovine.id = sirovine_izlaz.id_sirovine AND sirovine_izlaz.id_proizvodnja_pekara IN 
(SELECT id FROM proizvodnja_pekara WHERE proizvodnja_pekara.datum > Date('Form1.DateTimePicker1'))) AS 'sirovine.PROBA' FROM "sirovine" 

Anyone know what's syntax should be used in my example?

Re: [SOLVED] How to include date from DateTimePicker in SQL Query?

Solved by myself. If anyone has same problem, right syntax for using DateTimePicker date in query is

{DateTimePicker1}