Skip to Content
Author's profile photo Suman Thangadurai

Using Current Date in the Prompt/Filter

Dear All,

Many times i used to saw some query’s about how to pass the current date filter for the dashboard. You can achieve this using Combo box or Calender component, but query prompt selector is not working on this logic.

Let me explain in detail how to use the combo box :

Use the today function =today() to identify the current date in excel level. Take the list of values to the combo box from the label, you can directly bind the values into the combo box using query data also.

ScreenHunter_02 Nov. 24 15.00.gif

Goto -> Behavior tab and select the cell where the today function is used.

ScreenHunter_03 Nov. 24 15.08.gif

Then as-usual you can bind the source and destination cell. If you are binding the values directly to the combo box just bind the destination.

Use the destination cell to trigger the query. In my case i have used the query refresh button which will be hided behind the components to trigger the query.

Using Calender component is way simpler than using the combo box, use the date “Insertion type” and bind the destination. Follow the same method for using the query refresh button.

ScreenHunter_04 Nov. 24 15.17.gif

ScreenHunter_05 Nov. 24 15.17.gif

Hope this Helps!!!

Please let me know your valuable feedback’s or any option to use the query prompt selector on passing the current date.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.