Post reply

Grouping Data by week on a daily basis

  • April 9, 2006 at 12:40 am

    #112484

    Hi,

    I want to group the data for last week on a daily basis.

    For example, if I have today's date the result should be the distinct people in the last one week from today.

    If I have tomorrow's date the result should be the distinct people in the last one week from tomorrow.

    Your answer would be of a great help.

    Thanks,

    KV

  • April 9, 2006 at 1:31 am

    #631634

    you can make use of datediff(day, -7, yourdate) to get last one week date

  • April 9, 2006 at 1:49 am

    #631635

    if you still have problem, post your table structure some sample data and the result that you want.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply