topic Date Range in App Development

Date Range

olguita2014 — Thu, 23 Mar 2017 03:25:24 GMT

Hi,

I want to select year and month, for example year=2017 and month=January.

And in the advanced expression, to show data since January 2016 to January 2017.

Currently my expression is:

COUNT(distinct {<[Año_Emision_Poliza]={">=$(=Max(Año)-1)<=$(=Max(Año))"}>}Cod_Contratante)

But It does not work when I select the month

Please help me!!!!!!!!!!

Re: Date Range

aarkay29 — Thu, 23 Mar 2017 03:50:22 GMT

Try this

COUNT(distinct {<[Año_Emision_Poliza]={">=$(=Max(Año)-1)<=$(=Max(Año))"},Month=>}Cod_Contratante)

Re: Date Range

olguita2014 — Thu, 23 Mar 2017 13:57:47 GMT

Hi,

I want select month, no eliminate Month

Re: Date Range

aarkay29 — Thu, 23 Mar 2017 15:36:28 GMT

If you want to select month and get values!

COUNT(distinct {<[Año_Emision_Poliza]={">=$(=Max(Año)-1)<=$(=Max(Año))"}>}Cod_Contratante)

Can you please tell me, What do yo mean by the above expression of yours not working??

Re: Date Range

olguita2014 — Thu, 23 Mar 2017 16:31:14 GMT

This expresion is correct but I want since January 2016 to January 2017 or since February 2016 to February 2017,

since March 2016 to March 2017.

Depend of my selection of Month and Year.

if I select January 2017, in my expression I need to show data since January 2016 to January 2017

Re: Date Range

aarkay29 — Thu, 23 Mar 2017 17:30:26 GMT

Something like this should work

=COUNT(distinct {<[DateField]={">=$(=MonthStart(AddMonths(Max([DateField]),-12)))<=$(=MonthEnd(Max([DateField])))"},[Month]=>}Cod_Contratante)