Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
Please anyone help on this start date and end date selections.
I created variables for startdate and end date.
I put a OnOpen trigger for date fields in document properties.
Still its not working. Whenever i select the start date and end date the sales should be displayed with in that range.
Any another way to fix this.
Thanks in advance
Hi Kumar. Check this
Hi Kumar,
Please find attached document and hope this helps. For the above scenario to work no need to have trigger this can be achieved in Set Analysis.
Thanks,
Vivek
there is no Connection between your datevariables and your field date. So within a table box you will see al Dates.
you Need to use a straight table and define a caluclated Dimension like
=if (Date>=startdate and Date<= enddate, Date)
by the way: your on open Trigger is not correct as it only Shows <= value
use instead (i suppose you donot give an absolut date, but a variable? a field? thenyou Need to work with $)
='>="27.08.2018"<=$(=Today())'
Hi Kumar. Check this
Dear Andrey,
This what i expected. thanks for your great help. There is a variable actions we need to give.
Thanks
You're always welcome and I'm glad I was helpful.