stevegray
4Penny.net
Points: 55409

6/3/2016 2:16:29 PM

Get the first day of the week from a week number

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

There's a feature in SQL that allows you to get the week number of a date. This is usefull in grouping all the detail in a query by week.

So, now you need to report on the first day of the week. This snippet will give you the first day of the week for a given week number.

In the example we're using the Project Cost transaction table... but any table with a date will do.

 

4Penny.net
Version: All
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3