Hi,
I have an object called: [Visitor].[Arrivaldatetime]. It's in text, hence I am converting it to dd/mm/yyyy.
I have a report that will run at 9am on a Monday morning, but I need data for the previous week - i.e. 00:00:01 from Mon to 23:59:59 to Sunday.
This statement doesn't work that great: [Visitor].[Arrivaldatetime] > CONVERT (varchar, DATEADD(day, - 6, GETDATE()), 101), as it pokes in the following Monday which I don't need.
Help please!
Thanks!
I have an object called: [Visitor].[Arrivaldatetime]. It's in text, hence I am converting it to dd/mm/yyyy.
I have a report that will run at 9am on a Monday morning, but I need data for the previous week - i.e. 00:00:01 from Mon to 23:59:59 to Sunday.
This statement doesn't work that great: [Visitor].[Arrivaldatetime] > CONVERT (varchar, DATEADD(day, - 6, GETDATE()), 101), as it pokes in the following Monday which I don't need.
Help please!
Thanks!