Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to know how to select range of dates in the listbox when selecting start date and end date in the inputbox using macros??
Please help me out!!
Hi Gaayathri,
This is possible by using Set Analysis. I am not sure why you wanted to use the Macros. I would recommend you to avoid using Macros whenever possible, unless you have different requirement.
I am attaching an example for your reference. Here is the function I have used to get this working.
SUM( {<MyDate ={">=$(vStartDate) <=$(vEndDate)"} >} Sales)
Where vStartDate and vEndDate are variables which capture the Input Field Values.
I hope this helps! Let me know if you have any questions.
Cheers,
DV
Hi DV,
Thanks a lot!!!! I got it
Regards,
Gaayathri