<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p><font size="+1">Prezados,</font></p>
<p><font size="+1">Desde já, obrigado pela ajuda.</font></p>
<p><font size="+1">Tendo duas variáveis com datas referentes a
determinada pessoa:</font></p>
<p>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</p>
<p>
<title></title>
<meta name="generator" content="LibreOffice 5.1.3.2 (Linux)">
<style type="text/css">
body,div,table,thead,tbody,tfoot,tr,th,td,p { font-family:"Arial"; font-size:x-small }
a.comment-indicator:hover + comment { background:#ffd; position:absolute; display:block; border:1px solid black; padding:0.5em; }
a.comment-indicator { background:red; display:inline-block; border:1px solid black; width:0.5em; height:0.5em; }
comment { display:none; }
</style>
<table border="0" cellspacing="0">
<colgroup width="151"></colgroup> <colgroup width="161"></colgroup>
<tbody>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" align="center"
height="17">NASCIMENTO<br>
</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" align="center">DATA_FATO<br>
</td>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center" height="17">26/11/97</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center">23/02/15</td>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center" height="17">20/03/99</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center">28/03/15</td>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center" height="17">14/05/99</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center">08/04/15</td>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center" height="17">06/05/98</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center">08/04/15</td>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center" height="17">03/01/00</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center">08/04/15</td>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center" height="17">19/05/97</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center">08/05/15</td>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center" height="17">01/02/01</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center">17/05/15</td>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center" height="17">28/11/97</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center">03/06/15</td>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center" height="17">10/02/00</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center">03/06/15</td>
</tr>
</tbody>
</table>
</p>
<p><font size="+1">Como procedo para criar mais uma coluna que
calcula a idade no dia da ocorrência de determinado fato? De tal
forma que obtenha:</font></p>
<p>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</p>
<p>
<title></title>
<meta name="generator" content="LibreOffice 5.1.3.2 (Linux)">
<style type="text/css">
body,div,table,thead,tbody,tfoot,tr,th,td,p { font-family:"Arial"; font-size:x-small }
a.comment-indicator:hover + comment { background:#ffd; position:absolute; display:block; border:1px solid black; padding:0.5em; }
a.comment-indicator { background:red; display:inline-block; border:1px solid black; width:0.5em; height:0.5em; }
comment { display:none; }
</style>
<table border="0" cellspacing="0">
<colgroup width="151"></colgroup> <colgroup width="161"></colgroup>
<colgroup width="85"></colgroup> <tbody>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" align="center"
height="17">NASCIMENTO</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" align="center">DATA_FATO</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" align="center">IDADE</td>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center" height="17">26/11/97</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center">23/02/15</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdval="17" sdnum="1046;"
align="center">17</td>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center" height="17">20/03/99</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center">28/03/15</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdval="16" sdnum="1046;"
align="center">16</td>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center" height="17">14/05/99</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center">08/04/15</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdval="15" sdnum="1046;"
align="center">15</td>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center" height="17">06/05/98</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center">08/04/15</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdval="16" sdnum="1046;"
align="center">16</td>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center" height="17">03/01/00</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center">08/04/15</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdval="15" sdnum="1046;"
align="center">15</td>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center" height="17">19/05/97</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center">08/05/15</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdval="17" sdnum="1046;"
align="center">17</td>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center" height="17">01/02/01</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center">17/05/15</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdval="14" sdnum="1046;"
align="center">14</td>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center" height="17">28/11/97</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center">03/06/15</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdval="17" sdnum="1046;"
align="center">17</td>
</tr>
<tr>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center" height="17">10/02/00</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdnum="1046;0;@"
align="center">03/06/15</td>
<td style="border-top: 1px solid #000000; border-bottom: 1px
solid #000000; border-left: 1px solid #000000;
border-right: 1px solid #000000" sdval="15" sdnum="1046;"
align="center">15</td>
</tr>
</tbody>
</table>
</p>
<p><br>
</p>
<p><font size="+1">Valeu, gente!</font><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
</body>
</html>