Grouping By Week

2 posts, 0 answers
  1. Jerry Jansen
    Jerry Jansen avatar
    47 posts
    Member since:
    Aug 2009

    Posted 25 Mar 2010 Link to this post

    I have a time sheet report in vb that I want to create subtotals (grouping) by weekly. How can I do this?

    My date field is tim_date which is from SQL as datetime field.
  2. Chris Gillies
    Chris Gillies avatar
    384 posts
    Member since:
    May 2006

    Posted 30 Mar 2010 Link to this post

    I don't know for a easy way to determine the week of the year. But have you tried with a User Function. They have a help article that describes the user functions or check the video of the Product Sales demo on their site.
Back to Top