Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.