You can also check out the online help: Date Time Functions
It is also important to note how the date is being interpreted in Qlik Sense. You can see this in the Data Model Viewer: (see screen shot below)
Let us know how you do:
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
thanks for your quick reply Michael.
1)the issue is i want to load data from informix database.i established the connection by using drivers in qliksense. here it is fine
2) data load editor it is showing that table which i want .when i loading in qliksense it i showing that table not found in database. but it is there.
3)that same table loaded in qlikview it is working