autocount on enddate field

gundamhybrid · Post by **gundamhybrid** » Tue Jan 10, 2017 8:57 pm

Hi all,

please, can anybody can help me?

I have table_holiday like this :

date | description
25 Dec 2016 | Christmas
1 Jan 2017 | New Year Holiday
2 Jan 2017 | Company Holiday

so I want to autocount on enddate field (on table_meeting_date) with 12 meeting every Monday and Tuesday, exclude the table_holiday.
startdate | enddate
16 Dec 2016 | ???

mobhar · Post by **mobhar** » Thu Jan 12, 2017 10:06 am

Use PHP strtotime() function to convert a date and add param "1 day" to increment one day, and then check whether the new date is not a holiday, and not Monday and not Tuesday, to exclude them from your undesired dates.