Skip to content
Advertisement

rowCount for items over 45 days old

I have a table and use this to show me how many days the widgets have been in stock, this is the code I am using for this

I have info boxes at the top of the screen giving me different widget info, what I wanted is one of these info boxes to give me a total of how many widgets have been in stock for 45 days +

I am using this code for other sections of the site but I hate working with days/dates and simply cannot get my head round where and how I put the count in for the ones over 45 days

Advertisement

Answer

The query should look like this:

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement