RE: Witango-Talk: <@SECSTOTIME> tag
That's what I thought, maybe a new tag could be created for the next version. my work around: <@ASSIGN NAME="vdays" VALUE="<@CALC EXPR='floor(<@VAR vtrackdaycnt[<@currow>,5] SCOPE=Request>/86400)'>" SCOPE="request"> <@IF EXPR="@@request$vdays>0"> <@ASSIGN NAME="vsecremain" VALUE="<@CALC EXPR='<@VAR vtrackdaycnt[<@currow>,5] SCOPE=Request>-(86400*@@request$vdays)'>" SCOPE="request"> @@request$vdays days, <@SECSTOTIME SECS="<@VAR vsecremain SCOPE=Request>" > <@else> <@SECSTOTIME SECS="<@VAR vtrackdaycnt[<@currow>,5] SCOPE=Request>" > Ted From: Dale Graham [mailto:[EMAIL PROTECTED] Sent: Friday, January 20, 2006 1:50 PMTo: witango-talk@witango.comSubject: Re: Witango-Talk: <@SECSTOTIME> tag For time, it is <@secstotime >. But the amount of time has to be less than 86400 (e.g., something less than 24 hrs) For info on days, hrs, mins, you would need <@secstots > to get the day - and have that in the correct format, too. To get elapsed time, I believe you have to use a calculation, get the seconds elapsed (e.g., between 1 pm yesterday and 3 pm today), and then do MORE calculations to get elapsed time in whatever increments. Someone on the list may be able to speak to this sort of calculation. Witango does a days elapsed calculation <@datediff >, but not an exact time elapsed calculation, as far as I know. On Jan 20, 2006, at 1:11 PM, Ted Wolfley wrote: the <@secstots> tag references a timestamp from January 1, 1970. I want the days, hours,minutes and seconds that have elasped from a total number of seconds. Ted From: Dale Graham [mailto:[EMAIL PROTECTED]] Sent: Friday, January 20, 2006 12:38 PMTo: witango-talk@witango.comSubject: Re: Witango-Talk: <@SECSTOTIME> tag Wrong metatag <@secstots > not <@secstotime > On Jan 20, 2006, at 11:49 AM, Ted Wolfley wrote: Hi, I get a "Invalid parameter !" error when I use <@SECSTOTIME SECS="105241">. Is this because the number of seconds is over 1 day in length? If this is so, I should divide the number of seconds by the number of seconds in a day and use the tag with the remainder? Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester 5637 West Henrietta Road West Henrietta, NY 14586phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: <@SECSTOTIME> tag
For time, it is <@secstotime >. But the amount of time has to be less than 86400 (e.g., something less than 24 hrs)For info on days, hrs, mins, you would need <@secstots > to get the day - and have that in the correct format, too.To get elapsed time, I believe you have to use a calculation, get the seconds elapsed (e.g., between 1 pm yesterday and 3 pm today), and then do MORE calculations to get elapsed time in whatever increments. Someone on the list may be able to speak to this sort of calculation. Witango does a days elapsed calculation <@datediff >, but not an exact time elapsed calculation, as far as I know.On Jan 20, 2006, at 1:11 PM, Ted Wolfley wrote: the <@secstots> tag references a timestamp from January 1, 1970. I want the days, hours,minutes and seconds that have elasped from a total number of seconds. Ted From: Dale Graham [mailto:[EMAIL PROTECTED]] Sent: Friday, January 20, 2006 12:38 PMTo: witango-talk@witango.comSubject: Re: Witango-Talk: <@SECSTOTIME> tag Wrong metatag <@secstots > not <@secstotime > On Jan 20, 2006, at 11:49 AM, Ted Wolfley wrote: Hi, I get a "Invalid parameter !" error when I use <@SECSTOTIME SECS="105241">. Is this because the number of seconds is over 1 day in length? If this is so, I should divide the number of seconds by the number of seconds in a day and use the tag with the remainder? Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester 5637 West Henrietta Road West Henrietta, NY 14586phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: <@SECSTOTIME> tag
Ted, You are correct in your original post, the secstotime can only accept values less then 60 * 60 * 24 (86400). You should find that <@SECSTOTIME <@CALC “[your > 86400 value] % 86400”>> should work. PS. I don’t know if it’s 0-86399 or 1-86400 Robert From: Ted Wolfley [mailto:[EMAIL PROTECTED] Sent: Friday, January 20, 2006 1:12 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: <@SECSTOTIME> tag the <@secstots> tag references a timestamp from January 1, 1970. I want the days, hours,minutes and seconds that have elasped from a total number of seconds. Ted From: Dale Graham [mailto:[EMAIL PROTECTED] Sent: Friday, January 20, 2006 12:38 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: <@SECSTOTIME> tag Wrong metatag <@secstots > not <@secstotime > On Jan 20, 2006, at 11:49 AM, Ted Wolfley wrote: Hi, I get a "Invalid parameter !" error when I use <@SECSTOTIME SECS="105241">. Is this because the number of seconds is over 1 day in length? If this is so, I should divide the number of seconds by the number of seconds in a day and use the tag with the remainder? Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester 5637 West Henrietta Road West Henrietta, NY 14586 phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: <@SECSTOTIME> tag
the <@secstots> tag references a timestamp from January 1, 1970. I want the days, hours,minutes and seconds that have elasped from a total number of seconds. Ted From: Dale Graham [mailto:[EMAIL PROTECTED] Sent: Friday, January 20, 2006 12:38 PMTo: witango-talk@witango.comSubject: Re: Witango-Talk: <@SECSTOTIME> tag Wrong metatag <@secstots > not <@secstotime > On Jan 20, 2006, at 11:49 AM, Ted Wolfley wrote: Hi, I get a "Invalid parameter !" error when I use <@SECSTOTIME SECS="105241">. Is this because the number of seconds is over 1 day in length? If this is so, I should divide the number of seconds by the number of seconds in a day and use the tag with the remainder? Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester 5637 West Henrietta Road West Henrietta, NY 14586phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: <@SECSTOTIME> tag
Wrong metatag<@secstots >not<@secstotime >On Jan 20, 2006, at 11:49 AM, Ted Wolfley wrote: Hi, I get a "Invalid parameter !" error when I use <@SECSTOTIME SECS="105241">. Is this because the number of seconds is over 1 day in length? If this is so, I should divide the number of seconds by the number of seconds in a day and use the tag with the remainder? Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester 5637 West Henrietta RoadWest Henrietta, NY 14586phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: <@SECSTOTIME> tag
Hi, I get a "Invalid parameter !" error when I use <@SECSTOTIME SECS="105241">. Is this because the number of seconds is over 1 day in length? If this is so, I should divide the number of seconds by the number of seconds in a day and use the tag with the remainder? Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester 5637 West Henrietta Road West Henrietta, NY 14586phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf