Ravi Kumar
Registered User.
- Local time
- Today, 22:44
- Joined
- Aug 22, 2019
- Messages
- 162
Dear all,
I have a query with the below SQL , which needs to show me the calibrated equipment for this month only.
but this is not working(no records shown) , but if I take out the month criteria all records are displayed even with the empty one.
could you please help , how can I filter the same.
I have a query with the below SQL , which needs to show me the calibrated equipment for this month only.
SQL:
SELECT [Instruments list].[EQUIPMENT number], [Instruments list].[Calibrated on mm/dd/yy] as [Calibrated on] , [Instruments list].[Next Calibration mm/dd/yy] as [Calibration due]
FROM [Instruments list]
where(( [Instruments list].[Calibrated on mm/dd/yy])=month(now()));
could you please help , how can I filter the same.