Problem with date

[Timario]

Hello. 

I'm trying to get information by date in expression 

Sum({<[Year-month], [need_date]={"> <=$(= Date( $(= today() - count_days ) ) ) "} >} values ). But it's not working in case you don't choose any value in filter, but works when company is chosen.

count_days is variable from table. I don't see difference between count_days and $(count_days) in this case.

Sorry for my english.

[kiranmanoharrode]

Hi,

Please check your expression,

Sum({<[Year-month], [need_date]={"> <=$(= Date( $(= today() - count_days ) ) ) "} >} values )

I think '>' sign highlighted in bold is causing the issue. 

[Timario]

Unfortunately, without sign expression shows 0

[anat]

can u check $(= Date( $(= today() - count_days ) ) ) ,[need_date] both date format are in syc or not?

[Timario]

  Yes... Both date are the same format. Main problem with variable is count_days. When I change on 90, expression works 

[anat]

in that case can u try by passing the number instead of using variable,if it works then check what's wrong in  variable 

[Timario]

How can I passing the number? 

The Date(today() - count_days, 'DD.MM.YYY') function returns the date I need

[vikasmahajan]

Sum({<  Company,[Year-month], [need_date]={"> <=$(= Date( $(= today() - count_days ) ) ) "} >} values )

Add more and try

Vikas

[Timario]

It doesn't work. And also need show one company, but this expression shows all companies

[Timario · Accepted solution]

Sum({<[Year-month]>}if([need_date]<=today()-[count_days]), values) 

It's solution. Thank's to all