I am looking to create a date field filter between current date at 4:0PM to tomorrow 3:59PM it should be calculated when ever the report run. I need help to implement this.
I think the best way to do this would be to create a custom query cached filter for your current date at 4:00. In mysql this would be:
timestampadd(HOUR, 16, CURDATE())
You can then set the default value to be "Max". For your next either link to filter, you can either link with a dynamic offset (+23 hours), or create a second custom query with +39 hours (from midnight on the current day).
Let me know if this makes sense.
Appreciate as always for your prompt replies and help. I will try and let you know.
I probably in a Friday mode and brain is not working. Would you please send me steps to create this custom query filter. When I clicked on the Filter "Submit Date" field, i see this option. am I doing something wrong? How would i use Submit Date between 4:00PM to next day 3:59PM?
when I try to use the defined values and select Current Date + 16 hours and Current Date + 39 hours It does not work properly.
see screen shot.
What I have noticed the Current Date in the defined values does not starts 00 hours it starts with current timestamp.
Just FYI, I am using BMC AR System and I am sure the direct database date function call will not work here.
If custom query is available to select, then it should be possible to use this.
You can then link the sub-query to this date value.
Unfortunately if this will not work, I am not sure that there is another good way to achieve what you are looking for outside of possibly stored procedure view.
Thanks for your help and time. I will try which i believe BMC has prevented to do direct SQL query. You can mark the answer correct and close the thread.
Sounds good, sorry for the trouble.
Comments have been locked on this page!