i want to create a button who make a selection for a saison. For example I qlick on a winter button and he select months jan, feb, nov, dec. I want to have the some with summer etc...
Can someboady help me?
can you explain in depth,we cant get what you are trying to tell.
Find the attached app
Can you please post sample file??It will helps us to provide a clear solution.
Create a season field in your calendar.
Month(Date) As Month,
Pick(Month(Date), 'Win', 'Win', 'Spr', 'Spr', , 'Sum', 'Sum', 'Sum', 'Sum', 'Aut', 'Aut', 'Sum', 'Sum') As Season.
Now add a listbox containing Season...
add 4 buttons with actions, winter should be
select in field yourmonthfield
search string (Jan|Feb|Nov|Dec)
Amazing, so much answers.
It is working now, but now I have the problemfor example I want to select Winter season for the months nov 2014, dec 2014, jan 2015, feb 2015 by one button who calls Winter.
What is your Date format?
or Sep 2015 ?
Dateformat is 09/09/2015
you can do it in many ways:
1.Create a flag or field for the winter in the script , based on the button selection using action you can select the same.
2.if the Months are fixed , split the month and year and based on button hit select the months
I created a field in the script what tells me the current months with year
DATE(MonthStart(InvoiceDate), 'MM - YYYY')
But how can I tell the button when I press year 2015 and button "winter" he should take month nov. 2014, dec. 2014 and jan.2015, feb. 2015
Use the script fragment i already gave you:
Pick(Month(InvoiceDate), 'Winter', 'Winter', 'Spring', 'Spring', 'Summer', 'Summer', 'Summer', 'Summer', 'Autumn', 'Autumn', 'Winter', 'Winter') As Season,
I am not sure what you are calling Seasons. Would November be both Fall and Winter? If so You might need fields in your master Calendar called Fall, Winter, Spring, Summer and write something in your script to complete that field.
Retrieving data ...