finding data submission date?

[richa]

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 --

[Yadira]

If it is a MySQL DATE column, it does not store values as month-day-year. In a proper RDBMS, how date values are stored is of zero concern to anyone writing queries to them. So if the column is named `date`, you can simply write

SELECT DATEDIFF( NOW(), date ) FROM tbl;

Hopefully it will help you. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --