Hi,
I would like to create a view to filter records from the last 6 months. e.g:
select * from Users
where
loginDATE > DATEADD(MONTH, - 6, GETDATE()) AND
loginDATE < DATEADD(MONTH, 0, GETDATE())
I am getting empty records with this although records do exist in the last 6 months!
The column being used for this purpose has 'datetime' as data type.
Thansk for your assistance!!!!
I would like to create a view to filter records from the last 6 months. e.g:
select * from Users
where
loginDATE > DATEADD(MONTH, - 6, GETDATE()) AND
loginDATE < DATEADD(MONTH, 0, GETDATE())
I am getting empty records with this although records do exist in the last 6 months!
The column being used for this purpose has 'datetime' as data type.
Thansk for your assistance!!!!