Using a button to create a selection

[nicalbert]

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

[nicalbert]

YES!!!!!!!!!!!

Thank you so very much for your help and time Marco. It is really appreciated.

Nicolas

[MarcoWedel]

you're welcome,

glad it helped.