Display a total from year to date.
I have a system where users sign in, and enter the number of contacts they made for the day. I need some way of displaying how many contacts they made for year to date, month to date, and week to date.
When they enter in the number of contacts, the table has an id field (their username id), a date field (yyyy-mm-dd), and a field for the number of contacts. Anyone know how I could create a function to display a total of the contacts year to date, month to date, and week to date?
Busy posted this at 09:24 — 23rd December 2004.
He has: 6,151 posts
Joined: May 2001
you could do a count from date field , not 100% sure how to write it out though
maybe another row with id, month, total
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.