Date set analysis

[wanyunyang]

Hi guys,

I have an expression like:

SUM({<DATE(FLOOR(SalesDate))={">=addyears(today(),-1)<today()"}>}Sales), but it's not returning back results. I guess it doesn't allow me to do something like: DATE(FLOOR(SalesDate)). I'm wondering how should I rewrite this function? 

[dplr-rn · Accepted solution]

Let take this step  by step

Your set syntax is wrong change to

SalesDate={">=$(=addyears(today(),-1))<$(=today())"}

on the floor part

i actually havent tried DATE(FLOOR(SalesDate)) in the set expression before. i would recommend doing this step in the script.

Is your salesdate a timestamp? if not you dont need the floor function