Limit Max(Day) = Day(DateTimeNow()) - 1

Hello all, is there a way so I can limit my Max day of the date to be my Day(DateTimeNow()) - 1 ?

 

For example:

Today, day 3, i want to see all the sales for every month in 2019 until day 2 ( Day(DateTimeNow()) - 1 )

 

Edit: When i try something like Max(Day([DATE])) = Day(DateTimeNow())-1, I just get "False" or "True".

 

(1) Answer

Login