(03-01-2019, 07:23 AM)php_rocs Wrote: @jelz2018,
What are the field names for the Month, Day and Year? This will be helpful in figuring out how the query statement should be written.
The field names are located in ats_leave_apps table where in if you check the attachment image the field name "multiple" is for Day, and the other are month and year. I'm not so sure on how to combine those fields multiple,month and year so that if the current date will be equal to those fields the query will count those and show in our dashboard. I hope I explained it well for your reference. Thanks a lot in advance.