topic Re: How to Write a Date Range in Using Set Analysis in App Development

How to Write a Date Range in Using Set Analysis

praveen1108 — Thu, 30 Mar 2017 17:11:28 GMT

Hello All,

I have a If Statement like this:

Count(If(Type = 'XXX' and Create_Date>=Date(Today()-14) and Create_Date < Date(Today()-7),ID) )

and i would like to re-write the same using Set Analysis..How can we write it..i tried writing this way but somehow no luck.

In Data Load Editor:

LET Vtoday14=Today()-14;

LET Vtoday7=Today()-7;

In the Expression:

Count({< Type = {'XXX'},Create_Date={">=$(Vtoday14)"} ,Create_Date={"<$(Vtoday7)"}) >} ID)

Any help will be appreciated.

Regards,

sunny_talwar — Thu, 30 Mar 2017 17:17:52 GMT

May be this

Count({<Type = {'XXX'},Create_Date={">=$(=Vtoday14)<$(=Vtoday7)"}>} ID)

praveen1108 — Thu, 30 Mar 2017 17:35:19 GMT

This gives me a a different result lets say X where as my If gives me Y.

sunny_talwar — Thu, 30 Mar 2017 17:35:50 GMT

What? No idea what the means?

praveen1108 — Thu, 30 Mar 2017 17:42:09 GMT

Hello Sunny,

The one you suggested is working but not giving me the correct result.

sunny_talwar — Thu, 30 Mar 2017 17:45:16 GMT

May be share a sample?