Set Analysis with conditions on fields of date types

[#1]

Hello,

I want to use the count function using a set analysis expression and with two conditions in it.

This is my expression:

= count({<ORDER_BOOKED_DATE>Today()-7, PROMISE_DATE<Today()+30>}LINE_NUMBER)

ORDER_BOOKED_DATE and PROMISE_DATE are fields of date type. So basically i want to count  orders that have been registered more than a week ago  and with a promised date less than a month.

This does not work. Is there something i'm doing wrong?

Help please!

Thanks.

Tatiana

[tresesco · Accepted solution]

Try like:

count({<ORDER_BOOKED_DATE={'>$(=Date(Today()-7))'}, PROMISE_DATE={'<$(=Date(Today()+30))'}>}LINE_NUMBER)

[Anil_Babu_Samineni]

May be create 2 variables like

LET Start = Today()-7

LET End = Today()+30

Then create like below

= count({<ORDER_BOOKED_DATE = {">$(Start)"}, PROMISE_DATE={">$(End)"} LINE_NUMBER)

Or

Simply change your expression to this?

count({<ORDER_BOOKED_DATE={'>$(=Date(Today()-7))'}, PROMISE_DATE={'<$(=Date(Today()+30))'}>}LINE_NUMBER)

[Kushal_Chawda]

=count({<ORDER_BOOKED_DATE={">$(=Date(Today()-7,'OrderBookedDateFormat'))"}, PROMISE_DATE={"<$(=Date(Today()+30,'PromiseDateFormat'))"}>}LINE_NUMBER)

[Anil_Babu_Samineni]

Mae sure to play around with date format if you have not set up like DD-MM-YYYY for Order and Promise

[ahaahaaha]

Hi Tatiana,

Try

= count({<ORDER_BOOKED_DATE={">=Date(Today()-7)"}, PROMISE_DATE={"<=Date(Today()+30)"}>}LINE_NUMBER)

Andrey

[#7]

Hi Anil,

I have already set up the Order and the promise day to the date format. I tried your expression but the count is 0 which is not normal

[#8]

Thank you guys for the help!

[#9]

Thank you Anil it works fine

[#10]

thank you it works!