[libreoffice-users] Re: How to get max date < today from list

Hello,

After considering your question, I think my answer was a bit insufficient. I
have attached a file to this post which does what I think you want. The
first sheet contains a list of items with a date that should correlate to
your music number/date sang, in no particular order. The second page sorts
the entries and extracts the "last date" for a piece ID provided on the
first sheet. I am using a French locale, so you may need to change the date
formats to yours to make the date display work.

If the upload link does not work, I will send the file directly to your
personal e-mail.

I hope this helps.

Rémy.
DateSorting.ods
<http://document-foundation-mail-archive.969070.n3.nabble.com/file/t489793/DateSorting.ods>  



--
Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy