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
.png "Luminary Alumni"){kind=icon}