Lyonel Posted July 4, 2017 Share Posted July 4, 2017 Hi, Any idea how I can apply a date time range selector on a "timestamp" database field? Thanks! Link to comment Share on other sites More sharing options...
Guest Posted July 5, 2017 Share Posted July 5, 2017 Hi @Lyonel It depends on where you want the date range selector to appear. This can be performed in the reporting function using a combination of the "User Prompted Value" and "Between Date/Time Selector" on the Filter Tab. This then presents you with a selection box when you preview, or run the report: Is this was you are looking for? Kind Regards Bob Link to comment Share on other sites More sharing options...
Lyonel Posted July 5, 2017 Author Share Posted July 5, 2017 Hi @Bob Dickinson, I know about the date time range selector and it works like a charm... if the field type in the database is a date time. But with timestamp it is a bit different. For example, in the table sys_notification_history: Link to comment Share on other sites More sharing options...
Guest Posted July 5, 2017 Share Posted July 5, 2017 Hi @Lyonel Ah I see - sorry for the misunderstanding. I don't think we have got anything specific to accommodate this in terms of the prompt options currently. I will check internally and come back to you. Kind Regards Bob Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now