Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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.