My Visual Database — format date

Re: format date

null@example.com (Step-in) — Thu, 17 Aug 2023 12:13:02 +0000

Don't work in real time. How to make the value in the text field change after changing the date?

P.S. I asked the question myself and I found solution:

procedure frmAddDecision_DateTimePicker1_OnChange (Sender: TObject);
begin
    frmAddDecision.Edit2.Text:= FormatDateTime('yyyy-mm-dd', frmAddDecision.DateTimePicker1.DateTime);
end;

Re: format date

null@example.com (v_pozidis) — Fri, 17 Jun 2022 17:27:03 +0000

Thank you, it works perfect

Re: format date

null@example.com (derek) — Fri, 17 Jun 2022 16:41:47 +0000

Hi,
Attached is one possible way of doing it.
Derek.

format date

null@example.com (v_pozidis) — Fri, 17 Jun 2022 15:36:17 +0000

hi ,
i like to convert the record imeragen which is a DATE variable in the format dd/mm/yyy to have it in an edit box

frmCreateProtypa.Edit21.Text:= SQLExecute('imeragen from Stoixeia WHERE id=' + IntToStr(frmCreateProtypa.TableGrid3.dbItemID));