Specific Date

[evansabres]

I have a field called nwEVENTDTE

I am creating a chart (straight table) using nwEVENTDTE as the dimension. I want to limit the dates that appear.

I only want to display nwEVENTDTE from 10/13/2016 through 4/5/2017.

I can't seem to get the structure of the calculated dimension correct. I am using

=if(nwEVENTDTE >='10/13/2016 <= 4/5/2017', nwEVENTDTE)

however this still displays dates before 10/13/2016.

[sunny_talwar]

May be this

=if(nwEVENTDTE >= MakeDate(2016, 13, 10) and nwEVENTDTE <= MakeDate(2017, 5, 4), nwEVENTDTE)

[sunny_talwar]

Or this

=if(nwEVENTDTE >='10/13/2016 and nwEVENTDTE <= 4/5/2017', nwEVENTDTE)

[evansabres · Accepted solution]

I used this however still was not working. I added a ' after initial date and before secondary date and it worked

=if(nwEVENTDTE >='10/13/2016' and nwEVENTDTE <= '4/5/2017', nwEVENTDTE)