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

[niclaz79]

Hi Tatiana,

Try the following:

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

[sunny_talwar]

What is your date field format here? (for ORDER_BOOKED_DATE and PROMISE_DATE)?

[#4]

Hi Talwar,

The date format is: DD/MM/YYYY for both fields

[#5]

Hi Niclas,

I have tried this but it doesn't work. The count gives a result of 0

[sunny_talwar]

Try this

=Count({<ORDER_BOOKED_DATE = {"$(='>' & Date(Today()-7, 'DD/MM/YYYY'))"}, PROMISE_DATE {"$(='<' & Date(Today()+30, 'DD/MM/YYYY'))"}>}LINE_NUMBER)

[#7]

Still doesn't work.

It says there is an error into the set modifiers expression

[prma7799]

Please share some sample data.

[sunny_talwar]

My bad, missed an equal sign, try this

=Count({<ORDER_BOOKED_DATE = {"$(='>' & Date(Today()-7, 'DD/MM/YYYY'))"}, PROMISE_DATE = {"$(='<' & Date(Today()+30, 'DD/MM/YYYY'))"}>}LINE_NUMBER)

[#10]

I double checked and  it seems like the second condition (PROMISE_DATE={"$(='<' & Date(Today()+30, 'DD/MM/YYYY'))"}) does not applied in the expression.