date functions inside set analysis

[#1]

Having trouble with dates and set analysis - the below does not resolve:

sum({< day={ date(my_date,'WWWW')}> } value)

Anyone know how to do date formatting inside set analysis?

[alexandros17 · Accepted solution]

All function inside set analysis must be used with $ expansion:

sum({< day={'$(=date(my_date,'WWWW'))'}> } value)

let me know

Pay attaention to date formats

[#3]

Try:

sum({<day = {'$(=date(my_date,"WWWW"))'}>}value)

[#4]

thanks, this is what I was looking for