• Registered: 2017-04-27
  • Posts: 81

Topic: Hot to get date from table or grid and store it in datetimepicker

Hello community,

Hot to get date from table or grid  and store it in datetimepicker

Post's attachments

Attachment icon test date.zip 336.46 kb, 388 downloads since 2017-05-10 

  • Registered: 2015-11-13
  • Posts: 652

Re: Hot to get date from table or grid and store it in datetimepicker

The function is SQLDateTimeToDateTime (). Place as part of combobox onChange event.


procedure Form1_ComboBox1_OnChange (Sender: string);
begin
    Form1.DateTimePicker1.DateTime := SQLDateTimeToDateTime (sqlexecute('select _date from date where item =' + '''' + form1.ComboBox1.Text + ''''));
end;
  • Registered: 2017-04-27
  • Posts: 81

Re: Hot to get date from table or grid and store it in datetimepicker

thank you @ehwagner smile