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], ;
