Forum Discussion
Dion_tw
2 years agoFrequent Visitor
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...
BA_Pete
2 years agoSuper User
If you select your date slicer and go to Visual > Slicer Settings > Options > Style, you can change the slicer type to all sorts of different types:
If you use Between, Before, or After, this will create a slider with date entry fields with calendars behind them. If you make the slicer really small, the slider part of it will disappear and you'll just be left with the date entry elements.
Have a play with that and see if anything works for you.
Pete
Dion_tw
2 years agoFrequent Visitor
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_Pete2 years agoSuper User
Is your parameter defined as Text type instead of Date type?
Pete