1 of 1 people found this helpful
IF [Date] < dateadd('month',1,datetrunc('month',Today())) and [Date] >= datetrunc('year', Today()) THEN
Brilliant - it works.
Thanks a lot!
No worries, glad to help
The below calculations will also give the expected result:
IF [Date] <= TODAY() AND YEAR([Date]) = YEAR(TODAY()) THEN [Sales] END
IF [Date] <= TODAY() AND DATEDIFF('year',[Date],today())=0 THEN [Sales] END