Hello
Is there a way to add a script in the auto calendar that will help me in expression for selecting in semester to date sales ?
entries in the standard autocalendar are
If (DayNumberOfYear($1) <= DayNumberOfYear(Today()), 1, 0) AS [InYTD] ,
If (DayNumberOfQuarter($1) <= DayNumberOfQuarter(Today()),1,0) AS [InQTD] ,
If(Day($1)<=Day(Today()),1,0) AS [InMTD] ,
....
Num(Week($1)) AS [#Week],
Num(Month($1)) AS [#Month],
Ceil(Num(Month($1))/3) AS [#Quarter],
Ceil(Num(Month($1))/6) AS [#Semester],
Num(Year($1)) AS [#Year],
;
DERIVE FIELDS FROM FIELDS [D_SALES],
[D_TARGET]
Thanks for your help