Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
danosoft
Specialist
Specialist

Set Analisys take only the MAX month selected

Hi i have this set analisys to set my variable:

Set vFineMonthContrAlt = MonthEnd(MakeDate(GetFieldSelections(YEAR),Month(Date(Date#(GetFieldSelections(MONTH),'MM')))));

this take me the last day of my year month selected, for example if i select 2018 and 3 it will result: 31/03/2018

i wanna change it in this way:

if i select more months like 3,4,5   i want it result only the last day of the last month i selected, in this example so it must resutl: 30/05/2018

how can i set my variable for this?

thanks

21 Replies
danosoft
Specialist
Specialist
Author

yes, but when i call a field in alternative state i need to write:

Set vTipoScad = GetFieldSelections(STATO_OUT,';','','Contrattualizzato');

or is good and work to:

Set vTipoScad = GetFieldSelections(STATO_OUT,',','','Contrattualizzato');

?

olivierrobin
Specialist III
Specialist III

as this parameter is the separator of each element of the list, that could be any single character you want

so a comma should work