I want to get the number of days between the two dates. // DD-MM-YYYY $date[0] = "01-03-2023"; $date[1] = "30-03-2023"; echo date_diff(date_create($date[0]),date_create($date[1]))->d + 1; The program above returns 2, instead of the right number of days. >Solution : You should call date_diff()->days which returns the number of days between the 2 dates. Please change: echo… Read More PHP – Why date_diff returns unexpected result?
I have a large data frame in a panel structure (201720 rows; 3 columns) which looks as follows: Name <- c("A", "A", "A", "B", "B", "B") Inception <- c(as.Date("2007-12-31"), as.Date("2007-12-31"), as.Date("2007-12-31"), as.Date("1990-12-31"), as.Date("1990-12-31"), as.Date("1990-12-31")) Months <- c(as.Date("2010-01-01"), as.Date("2010-02-01"), as.Date("2010-03-01"), as.Date("2010-01-01"), as.Date("2010-02-01"), as.Date("2010-03-01")) df <- data.frame(Name, Inception, Months) I want to calculate the difference in months… Read More Is there a more efficient way to calculate the difference in months in R
I want to group within a group by date difference. For example, if there are 7 cases in facility A, but the first 5 cases happened before 14 days of the last 2 cases, I want them to be in two different groups (see below example) location address start_date start_date_diff Group Facility A 123 main… Read More Group by date difference in R