Find latest date

[leebo1973]

Good afternoon

I have a list of project, each of which have dates which work were carried out on them. Each project can have more than one date. I want to be able to find the last date that any work was carried out, and then calculate how many days have passed since that happened.

All help appreciated

Thanks

 

[namliam]

select max(yourdate) as lastdate, date() - max(yourdate) as dayspast from yourtable

Something like that?

 

[leebo1973]

Thanks for the reply

However, when a project has more than one entry, how do I find the latest entry on that project??

 

[namliam]

By taking this query I gave you and joining it back to your Original table.

 

[leebo1973]

Maybe i am sounding think, but not sure what you mean???

 

[namliam]

Take the query I gave you earlier, add your projectid (or some identifier), save it as qryMaxDate (or any name you see fit)
Make a new query, add yourtable, add this qryMaxDate join them and done....

 

[leebo1973]

Thanks, works a treat