go to post Steven Henry Su... · Jun 11 Hy @Oliver Thompson Sure, I'm trying to calculate the difference between the 2 dates/times, but the problem is, it has a different columns (date and time), so does it mean that I've to combine it into 1 columns (Ex: DateTimeorder ->combine Date and Time Order, and DateTimeUpdate -> combine date update and time update) then calculate them or any other way to do it ? Thank You Steven Henry
go to post Steven Henry Su... · Jun 5 Hy @Chris Stewart it doesn't work my friend, it because of order by I got an Info that Order by cannot used as Sub Query
go to post Steven Henry Su... · Jun 5 nice but it doesnt work, because of Order by, I've try and it give an Error but if I comment Order By, it works, but not what I want