Home Forums SQL Server 2005 Development Need help with DATE should be dynamic for every day summary. RE: Need help with DATE should be dynamic for every day summary.

  • July 7, 2015 at 10:01 am

    #1810755

    Ranzz (7/7/2015)

    Hi Palotaiarpad,

    the date logic is used in SQL agent t-sql code which runs @ 6AM in morning and exports a CVS file.

    when the job runs at 6AM it should extract data from 4PM(yesterday) to till date 6AM.

    ANDt.StartExport BETWEEN CAST('2015-07-06 16:00:00.000' AS DATETIME) AND CAST('2015-07-07 06:00:00.000' AS DATETIME)

    I guess in your date logic it is taking current time to yesterday date right ?

    Try this:

    ...

    AND t.StartExport BETWEEN dateadd(hour,-8,dateadd(day,datediff(day,0,getdate()),0)) AND dateadd(hour,6,dateadd(day,datediff(day,0,getdate()),0))

    ...