I am writing a sql query and I'm trying to determine the next available Sunday at 12:00 AM through the next Saturday 11:59 PM and I have the following query:
select dateadd(dd, ((datediff(dd, '17530107', MAX(payrolldate ))/7)*7)+7, '17530107') AS [Sunday] from dbo.payroll
where payrollran = 'No'
That gives me the next available Sunday with no time but I still don't have the following Saturday. Can someone please...
2 results in 0.0014 seconds.
-
How to get two 12 bit integers from 3 bytes
Does anyone know how to recover two 12 bit integers from 3 bytes
