Forum Discussion

Dion_tw's avatar
Dion_tw
Frequent Visitor
2 years ago

How to make a dynamic custom SQL query based on given date from the dateslicer?

Hey all,   I have managed to create a custom SQL query that is working fine. However, the start- and enddate are now hardcoded in the query itself.   I want to make it dynamic, so that when a us...
Need Help
Dion_tw's avatar
Dion_tw
Frequent Visitor
2 years ago

Yes, I knew if was possible in the settings. However, I don't have the option 'Between', 'Before' and 'After'. Maybe it has something to do with the parameter/data I am using?

BA_Pete's avatar
BA_Pete
Super User
2 years ago

 

Is your parameter defined as Text type instead of Date type?

 

Pete