majid.pervaiz
Registered User.
- Local time
- Today, 09:51
- Joined
- Oct 15, 2012
- Messages
- 110
Dear All,
I have a date in the table which is a future date i.e. "Next_Review_Date", this table contains several records.
What I would like to show is that only the records which are due in upcoming 2 months.
For example: an item is due for review on 28-August-2017, it should appear in the result of query. two months prior to 28-august-2017 will be 28-June-2017.
I am trying to use between and DatePart but it is not giving me the required result
I have a date in the table which is a future date i.e. "Next_Review_Date", this table contains several records.
What I would like to show is that only the records which are due in upcoming 2 months.
For example: an item is due for review on 28-August-2017, it should appear in the result of query. two months prior to 28-august-2017 will be 28-June-2017.
I am trying to use between and DatePart but it is not giving me the required result