[libreoffice-users] Re: Base Query Sort and Reports

Hi :)
Was this problem ever resolved?  It's generally better to start a new email
with a new subject-line and then copy&paste the lists address in.  Following
on from a previous thread make it difficult for people to find any good
answers or to pick up on where they might have been able to help.  
Regards from 
Tom :)  




capemayal wrote
> Perhaps you can add assistance with another query?
>
> I have created a parameter query with a case when statement :
>
> case when dateadd('dd', 365, "originaldate") <= dateadd('dd', 90,
> current_date) THEN 'Expired' else '' end AS "Message"
>
> [coding corrected from a subsequent email by Al]
> Problem is that instead of showing just the records that satisfy the
> parameter, it shows all records.
>
> If I solve that part, then the query will run exactly as I want it to.
>
> Thanks again,
> Al





--
View this message in context: 
http://nabble.documentfoundation.org/Base-Query-Sort-and-Reports-tp4031350p4032963.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted