11 Replies Latest reply: Jan 18, 2018 3:34 PM by Marco Wedel RSS

    Using a button to create a selection

    Nicolas Albert

      Hi everyone,

       

      I there a way to select dates using a button? I need to add a button that dynamically selects the last 7 days based on the current date.

       

      I tried the following, without any luck:

       

      • Created a button with "Select in field" as Action
      • Identified the date field (in this case ItemCreatedDate)
      • Used the following search string:  ='>=' & Date(Today()-7) & '<=' & Date(Today())
        • Just tried it... I'm not sure about that one!

       

      Does the format of ItemCreatedDate can influence the result? In this case, the format is "YYYY-MM-DD hh:mm:ss".

       

      Can somebody help me on that one?

       

      Nic