This topic is locked
[SOLVED]

 date_add now working

7/15/2019 4:32:54 AM
PHPRunner General questions
H
Hd_Mersintarim author

hi,
I'm using PHPR 9.8
my field is,

hasat_ed_tarih date

uygulama_tarihi date

ilac_hasat_arasi int
$values["hasat_ed_tarih"]= DATE_ADD($values["uygulama_tarihi"] ,INTERVAL $values["ilac_hasat_arasi"] DAY);

not working.

may you help me this about?

best regards.

admin 7/15/2019

DATE_ADD is MySQL function. In PHP it is similar but the syntax is slightly different.

$date = strtotime("+".$values["ilac_hasat_arasi"]." days", strtotime($values["hasat_ed_tarih"]));

$values["hasat_ed_tarih"] = date("Y-m-d", $values["hasat_ed_tarih"]);


More info:

https://stackoverflow.com/questions/2332681/add-number-of-days-to-a-date

H
Hd_Mersintarim author 7/15/2019

many thnx admin. code is working.

best regards.