Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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?
Kind regards
Mario
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.