Ravi Kumar
Registered User.
- Local time
- Today, 08:58
- Joined
- Aug 22, 2019
- Messages
- 162
Hi all ,
I have a query in which I need to filter only current month records , but using Month(now()) it is not filtering .
Below is my SQL , can you tell me how to do this?
I have a query in which I need to filter only current month records , but using Month(now()) it is not filtering .
Below is my SQL , can you tell me how to do this?
SQL:
SELECT [OT and Absenteeism by month].[Date of Entry By Month], [OT and Absenteeism by month].[Sum Of OT (hrs)], [OT and Absenteeism by month].[Sum Of Absentees (hrs)], [OT and Absenteeism by month].[Count Of Master_table]
FROM [OT and Absenteeism by month];