I have a Hire Date field as follows:
HireDate (datetime)
I want an indicator if the hire date is within this month or currentdate, next month or month after next.
If the month of currentdate falls within this month I want to assign it a '1'
if it is next month I want to assign it a 2
For the month after, I want to assign a 3.
I then want to filter and choose just those date records that fall with the current month through the next three months, using a calendar month. I do not think there is a function that would allow me to combine three months into one statement
HireDate (datetime)
I want an indicator if the hire date is within this month or currentdate, next month or month after next.
If the month of currentdate falls within this month I want to assign it a '1'
if it is next month I want to assign it a 2
For the month after, I want to assign a 3.
I then want to filter and choose just those date records that fall with the current month through the next three months, using a calendar month. I do not think there is a function that would allow me to combine three months into one statement