Welcome Guest, Not a member yet? Register   Sign In
How to show date rows equals current date?
#3

(This post was last modified: 03-02-2019, 02:04 AM by jelz2018.)

(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.
Reply


Messages In This Thread
RE: How to show date rows equals current date? - by jelz2018 - 03-01-2019, 05:43 PM



Theme © iAndrew 2016 - Forum software by © MyBB