How to show date rows equals current date? |
@jelz2018,
Almost there... add the red part: as d. I needed to represent the from source as a table. I named the table d. select count(employee_id) as count from ( select employee_id,year,month, case when LOCATE('-',multiple) > 0 then substring(multiple,1,locate('-',multiple) - 1) else multiple end as 1st_date, case when LOCATE('-',multiple) > 0 then substring(multiple,locate('-',multiple) + 1,length(multiple) - locate('-',multiple)) else multiple end as 2nd_date from ats_leave_apps ) as d where DATE(concat(year,'-',month,'-',1st_date)) >= CURDATE() and DATE(concat(year,'-',month,'-',2nd_date)) <= CURDATE() |
Welcome Guest, Not a member yet? Register Sign In |