Some reason below query is not working in BO 4.2 query builder. It is throwing an error message saying the it is not a valid query. Any idea?
Select * from CI_INFOOBJECTS WHERE SI_ENDTIME>DATEADD(DAY,1,SI_STARTTIME)
Basically I am adding 1 day on SI_STARTTIME and I am using SQL server.
Philip (BOB member since 2006-03-02)