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: [email protected]
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
