Hello Everyone,
I need help. I have a table with dates and other info and I'm trying to create a query that will show the date just before the most current date.
Example:
The result should be:
Hope I provided enough info for someone to help.
Thank you in advance.
I need help. I have a table with dates and other info and I'm trying to create a query that will show the date just before the most current date.
Example:
Code:
PS_Date Status
12/1/2017 E
10/1/2017 I
12/1/2016 E
6/1/2015 I
The result should be:
Code:
PS_Date Status
10/1/2017 I
Hope I provided enough info for someone to help.
Thank you in advance.