Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to select all days from the First of the Year to today. I want that users click on button and selection is made. How can I do this?
Add action to Button
Add
Selection
Select in Field
Field
Date
Search String
='>='&YearStart(Today()) & '<=' & Today()
You will need select in field action with the following Search String:
='>=' & Date(YearStart(Max(DateField)), 'YourDateFormat') & '<=' & Date(Max(DateField), 'YourDateFormat')
Manish,
Your solution works. But I have another question:
I'm working mainly with years, months and weeks; how can I get the same action for these 3 fields?
Can you elaborate little more on your requirements?
Yes, here it is.
I want to see sales made between the First of the year and today, but I didn't loaded a Date field: instead, I've loaded 4 fields: year, month, week and day (monday, tuesday...).
Now, my purpose is to have a selection in each of this field. In other words, if I click this button, I get selection:
- 2015 in Year;
- from January to September in Month;
- from 1 to 37 in Week.
(days aren't a problem).