Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
May be this
=if(nwEVENTDTE >= MakeDate(2016, 13, 10) and nwEVENTDTE <= MakeDate(2017, 5, 4), nwEVENTDTE)
Or this
=if(nwEVENTDTE >='10/13/2016 and nwEVENTDTE <= 4/5/2017', nwEVENTDTE)
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)