Assuming dateserial is required, the following result was found.
SSRS / MDX Date Querieshttps://joellipman.com/articles/microsoft/ssrs/ssrs-mdx-date-queries.html
+ cstr(year(today.now()))) ), "dd/MM/yyyy") // yields: 31/08/2011 This Year: -- Start Date (US format - mm/dd/yyyy) =DateSerial(YEAR(Today()),1,1) // yields: 1/1/2011 -- End Date (US format - mm/dd/yyyy) =DateAdd("d", -1,...