Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help selecting dates after a certain date

error.jpg

Sorry if this is simple... I'm reading my data from a pervasive sql database, everything works perfectly, but when I
add load "DDate" it always crashed with OLE DB multiple step operation error, I'm assuming it's because the DDate has too many

transactions (it's years worth of invoices).   How can I make DDate only load transactions after a certain date, E.g.  01/01/2013   ?
Thank you in advance

31 Replies
Not applicable
Author

I'm snooping in the Table, and see that "DDate" is of type   "Date" and in .net framework it says you need "

getdatetime()" function to get the date in format (dd-mm-yyyy hh.mm.ss).    does this help?

Not applicable
Author

http://www.pervasive.com/Portals/55/documents/PSQLv9/readme_v970.htm

I found the problem, it does not lay with Qlikview. The problem was PSQL V9.  The above hotfix for PSQL
address the following issue

58407

Invalid date/time/timestamp error from UDF called in a stored procedure

So this is sorted out. Thank you so much to all of you, I have no doubt your answers were perfect.