Error when creating calculated date query

English
#1

In this thread is a functioning AddDays.odb example of a query that calculates a date plus a number.
I tried doing this in this LANdpLAN database and I got an error. I copied tables from LANdpLAN into AddDays.odb and the query worked. What could the difference be between LANdpLAN.odb and their example?

download their example: Dropbox - AddDays.odb - Simplify your life
download LANdpLAN: https://www.dropbox.com/scl/fo/ca28jb693b39i0m3ortcs/h?rlkey=ugfv0umzslgxzb25kb0yhtoa5&dl=0

look for a query called “calculated_harvest” in both of the linked files and you will see that it works in one and not the other…

LANdpLAN calculated dates querry error
LANdpLAN calculated dates querry error1599×863 107 KB

#2

On my mobile I can’t check the databases, but did you read: The query in AddDays was saved as a view, wich is the reason, why formatting as a date was stored/remembered.

#3

Error says: Incompatible data type. So: Is “days_to_maturity” an INTEGER? Is “sewdate” a DATE?

You have created an external database. So I couldn’t test it with your database. Example has been created with internal HSQLDB.

#4

Yes. I did notice it said the view is necessary to display the correct date format. In the example the date formula gives a string of numbers in the query. I was not able to replicate this with my database.

#5

Yes. Thanks for pointing me in a promising direction. Maybe I have to discover the difference between an internal database and an external database to solvey problem …

#6

@goedible : It couldn’t be the difference between internal and external database. But: It would be to get an example with this error, which is an internal database. It is easier to reproduce for other people.

I would have a look at the data type.

#7

Would you like to open the ‘calculated_harvest’ query in the LANdpPLAN.odb to see if the error happens on other machines?

#8

I tried opening a report and got a longer error, maybe someone finds clues in here:

Screenshot from 2023-08-13 15-06-39
Screenshot from 2023-08-13 15-06-391429×745 171 KB

#9

This file is working with an external database. So I couldn’t test.

If you get this error with every report you wanted to start: Report Builder won’t work with packages from OpenSUSE, also won’t work with packages from Ubuntu. Use the original packages from https://www.libreoffice.org/download/download-libreoffice/

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.