Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I try to use variable vStartMonth in background color expression
vStartMonth = Date(Floor(Monthstart(Today()-1)), 'DD.MM.YYYY')
When I use specific date it works:
If(Count({<work_day={'1'}, Date_1={'1.12.2020'} >}distinct total Date_1)>0, rgb(162,233,171))
When I use variable it does not work:
If(Count({<work_day={'1'}, Date_1={'$(vStartMonth)'} >}distinct total Date_1)>0, rgb(162,233,171))
I tried plenty of tests with variable but everything was wrong.
Could you help me?
Thank you
let's try this:
=If( Count( {< work_day = {'1'}, Date_1 = {"$(=Date(Floor(Monthstart(Today()-1))+5, 'DD.MM.YYYY'))"} >} distinct total Date_1 ) > 0, rgb(162,233,171) )