Hi everyone,
I have one column in my main table that has the date formatted as mm-dd-yyyy. This is the date that a user has inputted data last, and they may do so only once daily. How can I write a query taking now() OR curdate() and subtracting max(date) to find out how many days it has been since the user has last submitted data? I end up getting a NULL set.
SELECT datediff((now(),'%m-%d-%Y'),max(date)) from foo
Looking for your reply guys.
Thank you in advance!
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --