Re: Get Start Date of a Week Number

Sounds like you are trying to calculate your column headings.

Let's say your first shipment date was 2014-08-20. And you want the
headings for 53 columns beginning with the Monday of that date.

To calculate the first Monday would be like this actual working sql
statement:
values date('2014-08-20') - (dayofweek_iso('2014-08-20') - 1) days

For imbedded sql you can do a VALUES INTO ColHeading(1)

Once you know that date it's quite simple to calculate the rest of the 53
columns:
for x = 2 to 53;
ColHeading(x)=ColHeading(1) + ((x-1) * 7) days;
EndFor;


Rob Berendt