Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to select from a list of selection a date. This selected date would then allow me to display the start date of the contract and the date of end of contract. So, we have a date interval in which our selected date must be included. I use "set analysis" but it does not work ".
=Sum({$
<[Année début de validité] = {">=$(=Année1)"}>*
<[Année fin de la période de validité] = {"<=$(=Année1)"}>*
<[Mois début de validité] = {">=$(=Mois1)"}>
*<Mois1 = {"<=$(=[Mois fin de la période de validité])"}>
} [Début de validité])
I try with the calendar, with one date but i only have dates who are =([Début de validité] & '<=' & Date), i want, from this script, get all the values who are !=null and where Date is <= [Fin période de validité].
Thanks
Ok, i have a correct answer. I have used some MakeDate function to regroup my field Year and Month together and compare them to my date with this setAnalysis :
=Sum({$ <YMD = {"<=$(=YM)"}> * <YMF = {">=$(=YM)"}>} [Début de validité])
Lexique : YMD : Year,Month,Début; YMF: Year,Month,Fin and YM: Year,Month
Have a nice day,
Alex