I am trying to hook my SQL DB to a report engine that says it supports SQL 92. I dont really know what that means, except that it cant handle this part of my SQL statement.
Can someone tell me how I can accomplish the same thing as this using sql 92 standards? Basically I need to get all the date for 'Yesterday'
(MESSAGESENDERCATEGORYVIEW.CompleteDATE >= DateAdd(Day,DateDiff(Day,0,GetDate()-1),0) AND MESSAGESENDERCATEGORYVIEW.CompleteDATE<DateAdd(Day,DateDiff(Day,0,GetDate()),0))
Can someone tell me how I can accomplish the same thing as this using sql 92 standards? Basically I need to get all the date for 'Yesterday'
(MESSAGESENDERCATEGORYVIEW.CompleteDATE >= DateAdd(Day,DateDiff(Day,0,GetDate()-1),0) AND MESSAGESENDERCATEGORYVIEW.CompleteDATE<DateAdd(Day,DateDiff(Day,0,GetDate()),0))