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
