SanjayGMusafir
Well-known Member
- Joined
- Sep 7, 2018
- Messages
- 1,513
- Office Version
- 2024
- Platform
- Windows
Hi Experts
Got stuck up at a place
I'm using following function in VBA to get amounts in last 2 hours
The challenge is when VBA runs, it automatically adds space(s) before and after ">=" as " >= "
Thus resulting in calculation error.
Please help or give a workaround.
Thanks in Advance
Got stuck up at a place
I'm using following function in VBA to get amounts in last 2 hours
VBA Code:
x9 = Evaluate("SUMIFS(Visits[Fees],Visits[VDt],TODAY(),Visits[VTm],">="&NOW()-TODAY()-(2/24))")
The challenge is when VBA runs, it automatically adds space(s) before and after ">=" as " >= "
VBA Code:
x9 = Evaluate("SUMIFS(Visits[Fees],Visits[VDt],TODAY(),Visits[VTm]," >= "&NOW()-TODAY()-(2/24))")
Thus resulting in calculation error.
Please help or give a workaround.
Thanks in Advance