Excellent - thanks!  Just what I needed!
----- Original Message -----
Sent: Monday, October 28, 2002 5:15 PM
Subject: RE: Witango-Talk: Convert numeric day of week to date II

Ok,

 

Let me resend this, so that you can see the formatting

The last one, didn�t keep the CRs when is Changed it to Text reply L

I have attached my working taf

 

 

<@! COMMENT="Set first date of the Year">

<@assign name='dayone' value='<@format str="01/01/2002" format="datetime:%m/%d/%Y">' scope='local'>

<@! COMMENT="get 1st offset based on sunday">

<@assign name='offset' value='<@format str="@@local$dayone" format="datetime:%w">' scope='local'>

<@! COMMENT="factor for start monday ">

<@assign name='offset' value='<@CALC EXPR="(@@local$offset - 1)">' scope='local'>

<@! COMMENT="Set week number">

<@assign name='weeknbr' value='44' scope='local'>

<@! COMMENT="Calc Date">

<@assign name='RetDate' value='<@DAYS DATE="@@local$dayone" DAYS="<@CALC EXPR='((@@local$weeknbr - 1) * 7) - @@local$offset'>">' scope='local'>

 

<@! COMMENT="Display values">

Week Nbr:@@local$weeknbr<br>

Week Date:@@local$RetDate

 

Ben Johansen - http://www.pcforge.com
Authorized Witango Reseller
http://www.pcforge.com/WitangoGoodies.htm 
Latest downloads & List Archives @
http://www.witango.ws

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dave Machin
Sent:
Monday, October 28, 2002 4:08 PM
To: Multiple recipients of list witango-talk
Subject: Re: Witango-Talk: Convert numeric day of week to date

 

Right, but I need to go the other way around.  I have the value 44 and need to convert it to "October 28th, 2002"

----- Original Message -----

From: Ben Johansen

Sent: Monday, October 28, 2002 3:36 PM

Subject: RE: Witango-Talk: Convert numeric day of week to date

 

<@assign name=�weeknbr� value=�<@format str=�<@currentdate>� format=�datetime:%W�>� scope=�local�>

@@local$weeknbr

 

use %U for Sunday first day week

use %W for Monday first day of week

Ben Johansen - http://www.pcforge.com
Authorized Witango Reseller
http://www.pcforge.com/WitangoGoodies.htm 
Latest downloads & List Archives @
http://www.witango.ws

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dave Machin
Sent:
Monday, October 28, 2002 3:11 PM
To: Multiple recipients of list witango-talk
Subject: Witango-Talk: Convert numeric day of week to date

 

I need to find a clever way of converting the numeric day of the week (this week is week 44).  To the date of the first day of that week (say, 10/28/2002) using Tango.  Does anyone have a quick way to do that?


Dave Machin

 

Reply via email to