How Edit Script Calculator datediff When DateTimePicker On_Change

I remember having the need to count the elapsed time to manage quarantine at some point but I was using SQL statement with "julianday" function:

select .......,

round(julianday('now') - round(julianday(<starting_date>))

from table

more here : http://www2.sqlite.org/cvstrac/wiki?p=D … eFunctions

Hi Prahousefamily,
Picking up on Tcoton's answer, you could try something like this to output it as a label;

procedure Form1_DateTimePicker2_OnChange (Sender: string);
begin
  form1.Label4.caption:= inttostr(daysbetween(form1.datetimepicker1.date,form1.datetimepicker2.date));
end;

It only shows the elapsed period in 'days', not as 'years, months and days', but the principle is the same.

I knocked up a quick project to show it working if you need to have a look.

Good Luck,
Derek.

prahousefamily
Example for you.
But you can't use TextBox for entering a date.

tcoton
Checked, works, what exactly don't work?

The last label at the bottom of the form does not calculate anything

How have free license for the educational ?
i work in small hospital and free teach in "basic database and apply in your work" 
my student is children student ,doctor,nurse and people etc

by use my visual database 1.2 1.3 to 1.46 for teach because free edition 
but 1.47 and later not free and in i haven't  license

Thank You .... My Visual Database Example easy for my student

I also work in hospital and make program for my hospital. How can I get a free license for the educational?