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

[Ben Johansen]

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 To: Multiple recipients of list witango-talk 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

TestWeek.taf
Description: Binary data