Date

[hafaneh]

Hello,

im trying to do this 

Sum({<Date = {"$(=Date(Today() - 30))"}>} Stock*WAC)

to take the data for the date 30 days bofore i want it for only one day if its 1/nov i want 2/oct data how can i do it everytime i i try somthing i get 0 even tho i have data for the whole year  

[vincent_ardiet_]

Check in a textbox what   =Date(Today() - 30) is returning and see if this is matching the format of [Date].
For example, if [Date] is stored in YYYY/MM/DD format but the expression is returning a result in the format DD/MM/YY this will not work.