I'm attempting to do two things in a query, first convert a field to a more readable format and then doing a join so that I can data within a certain time frame. Here's the query that I have so far:
what I'd like to do is to add one line to this
where date >= (this value will be a variable that I'll be passing from a web page)
Can someone please assist?
Thank you
Code:
select moncalladd.opname, moncalladd.schedname, moncalladd.adddate, moncalladd.initials, dateadd(n,moncalladd.Timestamp, '12/31/1899')-([timestamp]/1000)/60/1440 +1 as date into temptable3 from mdr.dbo.moncalladd inner join mdr.dbo.moncalldelete on moncalladd.schedname = moncalldelete.schedname
where date >= (this value will be a variable that I'll be passing from a web page)
Can someone please assist?
Thank you
Comment