Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a pretty basic problem.
Sum({<[Date]={">=WeekStart(today(1),-1)<Weekend(today(1),-1)"}>}Amount)
For some reason this expression keep on returning a 0. I have run through all the date formats, and as i can see they are all DD/MM/YYYY
Can any of you see the problem?
Best Regards Jesper
Try this
Sum({<[Date]={">=$(=Date(WeekStart(today(1),-1)))<=$(=Date(Weekend(today(1),-1)))"}>}Amount)