SQL syntax question...

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!

Duplicate to: SQL syntax to give me Mon-Sun data for the previous week

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.