Forum Discussion
Date time based on user selection
Hi Team, i fetching data from Azure sql db through View, view have Event start Date , Event End Date, Event Start Time, Event End time. And I have Date and Time table and Date and time are filters so i need to wite below two conditions as per user selected on date and time the data will be filtered.
EventEnd>=startdatetimeofinterest(User selected date) AND EventStart<= startdatetimeofinterest(User Selected Date)
EventEndTime>=startdatetimeofinterest(User selected Time) AND EventStarttime<= startdatetimeofinterest(User selected Time)
6 Replies
Just a question to clarify - could this be accomplished by simple filtering based on start/end dates/times configured in the filter pane?
What I was getting at... why don't you try using the simple approach first and set up the filters in the filter pane.
