[pilot-db-list] RE: Pilot-db-list digest, Vol 1 #1040 - 2 msgs

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

I use calculations for times=2E I can=B4t remember by heart, but something=
 like
these:

Check if field is current date: (eq (int %0) (int (gcd)))

Ellapsed days: (- (int (gcd)) (int %0))

Where %0 is an example field=2E

I took some time, but figured out scripts and filters to view and sort by
date: today, yesterday, this week, etc=2E for my daily logs and expenses=2E=

I=B4ll mail those later on (i=2Ee=2E in a few WEEKS)=2E

Michael Lees

Original Message:
-----------------
From:  pilot-db-list-request@lists=2Esourceforge=2Enet
Date: Sat, 28 Jan 2006 20:17:19 -0800
To: pilot-db-list@lists=2Esourceforge=2Enet
Subject: Pilot-db-list digest, Vol 1 #1040 - 2 msgs

Send Pilot-db-list mailing list submissions to
=09pilot-db-list@lists=2Esourceforge=2Enet

To subscribe or unsubscribe via the World Wide Web, visit
=09https://lists=2Esourceforge=2Enet/lists/listinfo/pilot-db-list
or, via email, send a message with subject or body 'help' to
=09pilot-db-list-request@lists=2Esourceforge=2Enet

You can reach the person managing the list at
=09pilot-db-list-admin@lists=2Esourceforge=2Enet

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Pilot-db-list digest=2E=2E=2E"

Today's Topics:

   1=2E Scripts and calculated time fields (J=2E Schmidt)
   2=2E Scripts and calculated time fields (J=2E Schmidt)

--=5F=5F--=5F=5F--

Message: 1
Date: Fri, 27 Jan 2006 14:55:05 +0100
From: "J=2E Schmidt" <mudshark1309@googlemail=2Ecom>
To: pilot-db-list@lists=2Esourceforge=2Enet
Subject: [pilot-db-list] Scripts and calculated time fields

------=3D=5FPart=5F47879=5F12558055=2E1138370105708
Content-Type: text/plain; charset=3DISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi folks,

some questions concerning scripts
and time fields:

1=2E is there a scriptlength limitation =3F
I am trying to set up an calculated field, which
evaluates the diff of two or more time fields=2E
The script seems to expand a "virtual length"=2E=2E=2E=2E

2=2E May a calculated field be used as input for
another calculated field =3F I always receive an error
message when i try anything alike=2E

3=2E May a script call another script =3F

4=2E Is there any application available (either Win or Unix)
which is aware of calculated, duration fields =3F

My actual approach to calculate the time diff
looks like :

(=3F (seq %4 HA)(dur (-(int %2)(int %1)))(dur(- (int %2)(int %1)30)))

I would like to expand this calculation =2E=2E=2E=2E=2E but no way=2E=2E=2E=
!!
Any good ideas =3F

Btw: i try to use the DB to keep track of my working hours
(office/home office =2E=2E=2E=2E=2E break for lunch=2E=2E=2E=2E) =2E=2E=2E=
=2E

Any comment is appreciated !!

Juergen

------=3D=5FPart=5F47879=5F12558055=2E1138370105708
Content-Type: text/html; charset=3DISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi folks,<br><br>some questions concerning scripts<br>and time fields:<br>=
<=3D
br>1=2E is there a scriptlength limitation =3F<br>I am trying to set up an=
 calc=3D
ulated field, which<br>evaluates the diff of two or more time fields=2E<br=
>
The script seems to expand a "virtual length"=2E=2E=2E=2E<br><br>2=2E May =
a=3D
 calculated field be used as input for<br>another calculated field =3F I a=
lwa=3D
ys receive an error<br>message when i try anything alike=2E<br><br>3=2E Ma=
y a s=3D
cript call another script =3F
<br><br>4=2E Is there any application available (either Win or Unix)<br>wh=
ich=3D
 is aware of calculated, duration fields =3F<br><br>My actual approach to =
cal=3D
culate the time diff<br>looks like :<br><br>(=3F (seq %4 HA)(dur (-(int %2=
)(i=3D
nt %1)))(dur(- (int %2)(int %1)30)))
<br><br>I would like to expand this calculation =2E=2E=2E=2E=2E but no way=
=2E=2E=2E!!<br>An=3D
y good ideas =3F<br><br>Btw: i try to use the DB to keep track of my worki=
ng =3D
hours<br>(office/home office =2E=2E=2E=2E=2E break for lunch=2E=2E=2E=2E) =
=2E=2E=2E=2E <br><br>Any co=3D
mment is appreciated !!
<br><br>Juergen<br><br><br>

------=3D=5FPart=5F47879=5F12558055=2E1138370105708--

--=5F=5F--=5F=5F--

Message: 2
Date: Fri, 27 Jan 2006 15:58:55 +0100
From: "J=2E Schmidt" <mudshark1309@googlemail=2Ecom>
To: pilot-db-list@lists=2Esourceforge=2Enet
Subject: [pilot-db-list] Scripts and calculated time fields

------=3D=5FPart=5F101=5F12731111=2E1138373935475
Content-Type: text/plain; charset=3DISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi folks,

some questions concerning scripts
and time fields:

1=2E is there a scriptlength limitation =3F
I am trying to set up an calculated field, which
evaluates the diff of two or more time fields=2E
The script seems to expand a "virtual length"=2E=2E=2E=2E

2=2E May a calculated field be used as input for
another calculated field =3F I always receive an error
message when i try anything alike=2E

3=2E May a script call another script =3F

4=2E Is there any application available (either Win or Unix)
which is aware of calculated, duration fields =3F

My actual approach to calculate the time diff
looks like :

(=3F (seq %4 HA)(dur (-(int %2)(int %1)))(dur(- (int %2)(int %1)30)))

I would like to expand this calculation =2E=2E=2E=2E=2E but no way=2E=2E=2E=
!!
Any good ideas =3F

Btw: i try to use the DB to keep track of my working hours
(office/home office =2E=2E=2E=2E=2E break for lunch=2E=2E=2E=2E) =2E=2E=2E=
=2E

Any comment is appreciated !!

Juergen

------=3D=5FPart=5F101=5F12731111=2E1138373935475
Content-Type: text/html; charset=3DISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi folks,<br><br>some questions concerning scripts<br>and time fields:<br>=
<=3D
br>1=2E is there a scriptlength limitation =3F<br>I am trying to set up an=
 calc=3D
ulated field, which<br>evaluates the diff of two or more time fields=2E<br=
>

The script seems to expand a "virtual length"=2E=2E=2E=2E 2=2E May =
a=3D
 calculated field be used as input for another calculated field =3F I a=
lwa=3D
ys receive an error message when i try anything alike=2E 3=2E Ma=
y a s=3D
cript call another script =3F
 4=2E Is there any application available (either Win or Unix) wh=
ich=3D
 is aware of calculated, duration fields =3F My actual approach to =
cal=3D
culate the time diff looks like : (=3F (seq %4 HA)(dur (-(int %2=
)(i=3D
nt %1)))(dur(- (int %2)(int %1)30)))
 I would like to expand this calculation =2E=2E=2E=2E=2E but no way=
=2E=2E=2E!! An=3D
y good ideas =3F Btw: i try to use the DB to keep track of my worki=
ng =3D
hours (office/home office =2E=2E=2E=2E=2E break for lunch=2E=2E=2E=2E) =
=2E=2E=2E=2E Any co=3D
mment is appreciated !!
 Juergen

------=3D=5FPart=5F101=5F12731111=2E1138373935475--

--=5F=5F--=5F=5F--

=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=
=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F
Pilot-db-list mailing list
Pilot-db-list@lists=2Esourceforge=2Enet
https://lists=2Esourceforge=2Enet/lists/listinfo/pilot-db-list

End of Pilot-db-list Digest

--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web=2Ecom/ =2E