Gossamer Forum
Home : Products : DBMan : Customization :

Re: [carlstevenson] comparing dates to get a number

Quote Reply
Re: [carlstevenson] comparing dates to get a number In reply to
Ive had a breakthrough!

I changed the following code from $rec to $in. and it works! I also divided the total by 86400 to get back to days since last visit.

Code:
sub modify_record {


my ($status, $line, @lines, @data, $output, $found, $restricted);

$compare1 = &date_to_unix($rec{'date'});
$compare2 = &date_to_unix($rec{'currentdate'});
$total = $compare2-$compare1;
$in{'food'} = $in{'food'} + $in{'addfood'} + $total;

to

Code:
sub modify_record {


my ($status, $line, @lines, @data, $output, $found, $restricted);

$compare1 = &date_to_unix($in{'date'});
$compare2 = &date_to_unix($in{'currentdate'});
$total = $compare2-$compare1;
$in{'food'} = $in{'food'} + $in{'addfood'} - ($total/86400);

See, i'm learning.
carl

Last edited by:

carlstevenson: Nov 4, 2002, 3:15 PM
Subject Author Views Date
Thread comparing dates to get a number carlstevenson 3239 Nov 2, 2002, 1:12 PM
Thread Re: [carlstevenson] comparing dates to get a number
LoisC 3171 Nov 4, 2002, 9:17 AM
Thread Re: [LoisC] comparing dates to get a number
carlstevenson 3161 Nov 4, 2002, 1:17 PM
Thread Re: [carlstevenson] comparing dates to get a number
carlstevenson 3154 Nov 4, 2002, 3:01 PM
Post Re: [carlstevenson] comparing dates to get a number
LoisC 3163 Nov 5, 2002, 9:19 AM