Set analysis to bring through data from today + the next 14 days

[#1]

Can some one help me with the correct expression that will provide episode level detail on records from today + the next 14days.

=Count({<SessionDate={">$(=Today()+14)"}>}ID)

[Kushal_Chawda]

=Count({<SessionDate={">=$(=today())<=$(=Today()+14)"}>}ID)

[sunny_talwar]

You might need to add Date functions here (especially for Today() + 14 part as this will be converted to a number as soon as your add 14

=Count({<SessionDate={">=$(=Date(Today(), 'DateFieldFormatHere'))<=$(=Date(Today()+14, 'DateFieldFormatHere'))"}>}ID)

[arvind_patil]

HI clinton,

I Think,both the expressions are correct use according to r need.

Thanks,

Arvind Patil