Cita:
Empezado por Casimiro Notevi
No somos adivinos, no sabemos qué son exactamente esos campos, se supone que devuelve la diferencia entre dos fechas, pero para eso no hace falta crear ningún procedimiento.
|
Hola de nuevo, lo siento, con las prisas y el cansancio no me expliqué. Tengo que recorrer una tabla y extraer la mayor diferencia entre dos fechas consecutivas.
![](https://www.clubdelphi.com/foros/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAZgAAACuCAIAAACEDYwGAAAgAElEQVR4nO19b6wlR5VffcFStFrsL3GUjRISw4DxWM2mYxBusV7HWJuskZVNkwhalknCTppFfgpLbpgA6959kbF3PATcd5iRd/eln82ClUcykyt5nCZ/nI7n2ZAIru1gsiPwTceOPbOeP/YQr7MsCI0rH7qr6tS/7nr3vvf6vPeqdD7cV11d/atzqn51TnXrHUJ98cUXX3Z4IUMD8MUXX3xZtBBffPHFl51bOJEtb6Ns8+Nwyt5RAvKRooWHFhhC8UQ2nOqHBuBHihweWmAIxRPZcKofGoAfKXJ4aIEhFE9kw6l+aAB+pMjhoQWGUDyRDaf6oQH4kSKHhxYYQhmYyE6U2gvUMl0m5MF8Rik9nXZ1Ymvjci8GaZWQ6iqglJYnhoa3+SNl5uamgZY6UUqj1i7N1iO1W1v9gvBEmZUnejuP8tOzpnH+4Aaf2ztRFwI2l2x07eBZaxiIzDAX9xCRSbA3YVkiFD5StiBbwkJJZAxDlK7P+neURTBIEzVK18tcedYiwOYTp7UDoOJZa0iJbBGl41GuoxIA7D1CZPRiHi0jJzLSOssNVJts0gSOjNy0CLAtEzPUwQUpkclkFJ3IZxeZU80bK23WZ6xBuRuITB5depoF3Y3GTpdlo5CLZcp6MGsJg8jmFk4ZdiIDajeqtwEJqDlq5l7T6DQjGogTjov/hv3AeTs3sGVCHsxLXsluBPBYZYPt4kxCAtWuzDQFqrZO+UNn66k0/NO5PmM3dY7hJ7K2TRotk8g2J0B92pxZ7HQiW47yi3yygh245YIyfZBpANQbtIRBZHOXJ9hwdgaRzfIH7erVfrenV7Y2RiLbsEfWC4xPHjCLBLxIuV04d5ra9ZkmQdXbn26QaPXSLN2CmYmByGDR7S2UvkxaC2mBidRmt4SWYsbYVgXYma1awiCyucsTbGjrO4bIrOpVMUTpibw8PZtxn2V5a4nMAqzhLzq7WKYPqlOlS4d2tfPbbUQmI9GpVhv+Js8xBETW6ZG1JpGL8mYTOi+7h8j4QKL1mZgihuk1yx+0awmDyOYuTxDpXS12IuN+jUm98h4zo5ReLPMTUQTfz24VkfUAk4NceY3YdNhDZLP8QRuRqf17IlMVqjB9f5tdQ2TNuC6WJXSvnDwyZMJHChYkO9O0sBUKIhMRvVW90pkGWMlbG1o6AFsmZDnih1blCe+RbYXIFnI/I7PNA20+7RIi46G3qNdPLrq1hEFkc7MFyZyyFmfzZ5k+SIiyWgYiMhMGTb3axCtPEBFGWAjLNoEdicwBmAh+hTuvQtVYxgTJNtM2ekbmiYyQZRJJfnJqOJjcfW8tW2mWN9hy1XdA4iDMrCUMIptbWZDg+9i0FIES+ObT8NU0OKjW6xeDJ8rFWQ6+OzWrV5rAAn9rIGad9LRpckoTmN0LDbcIMPjWkk0q+a2l4cjV9NZSn2kAqvtby11OZHtZnJTA/BReg+2N5KaN1MNDBmxnzTRPZMOp3qENPDMGNTtmermP1MPDBmxnzTRPZMOpvqdBe9infEC4s6aX20g9PIzAdtZM80Q2nOqHBuBHihweWmAIxRPZcKofGoAfKXJ4aIEhFEFkvvjiiy87tbREVtd024SQbX0cTtk7SkA+UrTw0AJDKJ7IhlT94Bj8SDHDQwsMoViJ7JlnLq2ulm9961tvueWW22677aabbrr++usJIWtr66dOvQBbHjt2vMPfW1k56S1kU/3gGPxIMcNDCwyhmIns+PFvNzR07z2f/r+v/eBPXj9/6bUz/+3b/+nD8a809aurJeziTa1cvnz5xRdfPHXqFCHk2LHj3kJG1Q+OwY8UMzy0wBCKgcjW1tavuuqq9SceOfVfH/n85z7xt//Wze961773vTf43Xv/6cOrh7721cOPfO1fEkK4X9YQ2etaefLJJ3/2s5+tra3pfpm30J5SAvKRooWHFhhCMRDZ/v37v/+9x//X80+99OKz//Gbf3jg43fc+P73feADf+Mf/cMP/8Hv3fPNf79y8tHf+/offpFr2UZkJ06cOHjw4J133nnzzTcrJpH/nGUhiEWTUkVZpIREWQVqqjwkaaE045VVDvsjhITZrL9Po1R5qNwuPUXGoAJQEJaJXCmUYBzOLhIEC7KZY42S4W8k8Pr0VuWhmK6zLHSYumDgSbEZeKo8DPPKcKlMmnprA7sUKSGE9N2VhTQpaF3RMKRVTZOQVow0+NAMREYIOXfm+//v9fN/8vqZC+efP/vSc3/0XPXkqX89OXH0ierr337q+H8o/9Xn/nlqJLL777+/4Y7777//pZdeuvfeez/0oV+9+uqrO4isSCB5zbJQ4bJZFpIkSaXKfiKDV8tE5TJTnzbjKZTkSmRRqEygIiVhFM5BZDuf5hZhiqrIk6zPTP2yC4iMr4uBiMwmc/AXl8JhDXIiax/X0lld0yLpI7LD93/m9dee+9lPzv/0T1/7yZ9d+smfvfqnb/zxqxd++L/r7xYr9//6x//eRz9ym05khw4dWlpaOn369BtvvLG0tHTo0KFLly5dunTpW9/6lp3IyqTb22r+NFbqCrVRTJEayMiFIKo8JGmWRYIHXYlMvqtRepZ7ItuYSAt4Edn5RBbmWdKsFEFkVRbZYo72UpgmnMga90ciRC1kEdEMm8lhmjTqaghL1DT9sE7aS3mlo6ryMEkTY7wFiayghFBCKEn4ECghlIQ0AR5ZEraVVS+RLS1l8d/9ldGn//FDxfjM//nv588++9KL3/3e97775S/9zsHPHPiNT3z0g7e8/93XXrO0lPEu3nzzzR/96EeEkO985zs//vGP33zzzTfeeIMQ8txzz7366qtPPfWUnch0F0yzR1LWNS0SYmATddJbKEamS3OfRmm7mmUh69CZyApppyoTjToNRMYYEMyDsp0BAj+vUai5mSg52IG1lnBeDrIgG0hhmiXNGCOw05askoRhXlRUPnMwxemGfpr6Ru028tqpRFZVedhyR5RVcAbavYEqD5v4C8zGdv0LEikTrZ92jcCQlmMgnE/lnkUDuTepRvMwGgySn8Voi9Cibn+I0NLdI6tr+ra3/aUbbvjFD/3qrb/xiY//5qfSu+468E+W7vzoRz50441//S9c/ed/4Reufttf+YtQ3ZcvX7506RIh5LHHHnvllVd++tOfvvzyyw2RXbx48cknn+wILcF60xkNWKhIRSy9YSKbycvb1KdReFdC485EBkOA5nYnImPcyr1I6S4xkCqLGPgyIaCy/W1qyaf1di1FzdyNrRu1QNJhB4gVratSEI3VI+vsZ7cSWU2LJMoqNq+AOwOXdGNxvkML2gIlzGZg8yuVpwgMsEZ4ZG1N+xSFyHRU4hYtKOaNuTtGKCE0zGiV0TCjrJ95iey6697+8MPHbr/95ve97xevu+6d73nPdVde+fM/93N/7qqrfv6mm95/ww373/GOt0F1X758+bXXXrvnnnvSND158uSpU6fuuuuuT33qU88+++yFCxeajzAsM1ufnUCzEtGI5boQkdn6NIroStsG+4lMzCdh0X4iAxug/iCpB8bIxhEZW0pnxkMsSBvRFCmBAQ7/s5vIDIS1y4msrvIwyeckMmPcw+hM8drU59ZbT2SJBGxziGz//nc88vXf/2b57z79m5/46leP/LPRr99883s/+ck7brzxPZ/85D/45V++4Z3v/KtQ3ZcvX7548eK5c+e+8IUvNFx0xx13ND+efvrpJ554wo3IuGaF76oWxS1Sb+wNLe19WsEAEoFelQORMRMyj9ottCx6KmGJsgq6ZlRy+LWWQx239RIZcCTZ/PZEZiSy5uWYIWSzhJbSxiaFhPyApRZnLFqwYiSyOULLXiKraEhoc0m8o2xCy5omc4eW11+/78SJr/3wh8998Yu/c/qPnjl06Lc++pG/85Wv/O5tt/3SZz9716/92i3vfvc1UN2XL1++cOHChQsXzp8/f/78+XPnzj399NN8DX3jG9+wEplyDF/LCjIwhX1BdlCMOUyT+zROJrm9fGCvzR7uGSm2LIClN4HItIH3e2Tm4WybeI9sUb0phAJPsrg/Jd/LLoG35+phf8OJhBAiH9o0Be7EAIM4ZiXgiM182C/ip14iq+2H/YSGyucXjof9NSOy55///gNf/hd1/T+P/9vfv/PO+OGHv3L77Td/7nNLRiI7d+7cH8vlsccegy6BZWbPslD6kIT7F/JnGZSrns1vdyITn1909WmcTEpXlfQ1RpEQhUHEaxrYxlSvTtMeIuPmBzGyvutazsg6fdXtXZDdBKSfkTX1GyCymXq+tjuIDI/o4eci4vb5hU2cQsvf/u3P/OAH3/vSl5br+vuQyD772btuvfX9116rEtkrr7zyyiuvcBY7e/bs2bNnH3300T4iawGJIk5tTY5S41upcZPMbtpVwzG/3qfNbPKlKotgY4jc/FIVfnk7H5Gp3/7p7zHBkJMUjFFriZfIqOmtZaPhiHCOE33a+ynS9nuAJE92jUeGRzadyAghYQ5P+t3E4YPYuqbvetdf++AHf+nLX77vYx/7+88//z8aIjt69Au3337znXd++Nprr3n72/8yVPfly5c5eZ09e/bMmTNnzpx5+eWXX3755UcfffSRRx7pJrK9KVujBAtZ78KR7n54aIEhFDORra6WV1xxxRVXXHHL34weeOC3Pv/5pVtv/cDS0sfe+97rg+DdhJC1tXXYxfr6+n9h5fHHH3/88cf/MygPP/zwvn37vYV01W9OVzD27PAud8FI9xg8tMAQipnIGjl69N9cccUVhJArr7zyLW95S+P2w/970cjy8lHSV+67bwW1hbRoVI3dtkb1m9UVP17dasyDj3RPwUMLDKF0EdmWPnXwkQ8ue0cJyEeKFh5aYAjFE9mQqh8cgx8pZnhogSEUQWS++OKLLzu3tEQ2ndJtE0K29XE4Ze8oAflI0cJDCwyheCIbUvWDY/AjxQwPLTCEYiWyqrp05Igh+cjKyvrJky/AlocPdyUfeeCBk95CNtUPjsGPFDM8tMAQipnIHnqoJ/nIkSMl7KI7+cjhw8e9hYyqHxyDHylmeGiBIRQDka2sOCUf4X4ZcUg+ovhl3kJ7SgnIR4oWHlpgCMVAZO7JR3gXLslHzBaa5IEajKZj6yVwVWkQl9LApHstt/Q/Dl5Kx6Y2wWjm9FyL6qdTOp3ORoGGf0rHsaHSVTjgjctkFLWDgmMJ8knbYDYKNOX04US+INHCk5dJNJpwE/DfvTIbBSQebwaeSR6IaQCljJt6awO7jFN5dpllFNB4TKcTGgR0MqVxQCdsHvKhGYiMOCcf4e1dko/YLSQtuXHMBta9GscpYAqZC8YpHOF0nBI+CTbyOMMltU0ZQy7reG73NJXGInqef/7NT2RlzG8cpx30Cnl2HPdARcsUyOERZb9vFT4QkdlkDv7iYppjurRE1j6upbOpPPHMROaYfIS3d0k+YreQvOSsrAFFW+diyzJYbjKKrOTY8Tj9kt5GcFDnc00CdKINx0BtG5xbc90u3LEpHceavzktY+OWME67N1W0TIEcnrRMgnwU8xneWmEyisyRAb8UpDGflmP2/8gEIWqBhXDD2YQP0jgghKTjhrBETdMP66S9lE90VJM8iNNYejQTSGRj9p8tYj4ESgglAY2BRxYHbeWkl8gOHHBKPnLgQMa7cEk+YrXQHETWsc6Nd3Ga23Qi42u7+7l960cJJCUSGYP/tt60gdNLmnzMrg0YdqPsJHZ0Bbd607YvjRGQmvS7Z6QIBS08hcgmbRTPTCPMoelfPgyJx5Lf1K5/QSLcDRf9TEYRiUtpAnMMisfAexYN5N6kGs0PaOch9LMYbRE6nrY/RGjp7pFNp07JR6C6XZKPWC2kB3R8jRGtNJc6XADzJeby9Dyu75KBrZg5u5/bu34kalY4Au6ofGbwbkED5SyP60pMo86uNJ4KWgMYA3MIsid+QcsUyOGpRDal4zgaTRiRAXdGie4Vz7qdn6AEo5lYX3wH1YNEWCM8sramfYpCZDoqcYu2O/LG3B0jlBAajOhkRIMRZf3MS2QuyUegul2Sj1gtJDOV7OXaPbL5iazjcX1Ito7IIBdYRwe3ODYhjI2VjdSgRktX0vsNSKb68CUvwBSH2kaKTtDC04lsOsmDOJ+TyIynUWzaK16b+tzp1hNZLAHbHCJzST4C1e2SfMRqIfm9ITjV27zQ0hgAdjzOdmmjoWVnzKXopHXmdVKQGFZ9lvkYTh2L8c2sBtuJQD2RDQFMDgw129lDS2kLl0JCPt+A+UA/zWQwEtkcoWUvkU1oQGhzSbyjbELLKY3nDi1dko9AdbskH7FaCK7/zjeMQHRPh9ds5LC/43HGS1t12A+eojxC9Yzc2MdIZL1dWRXO57flsN8T2VYDUwgFnmRxf0q+l12KAuthf8OJTfQBO28KP+zXPTJ42N/MCvNhvziy6CWyqf2wn9BA+fzC8bB/OnVKPgLV7ZJ8xGqhuT6/mIwiIp/RCGPsuM8vpmIUQRBJIQDwPU1bMdXOyOz01NuVwo+wHroD2ucX/oxsDwHTw89FxO3zC5s4hZa9yUegul2Sj5gtZA7WCHtjYihd7+CUTuDe4vS4vksaJG31Wp5rEsM0VahwSuV35KVw5i1f+RqO7cXv3q4kPuL7KtG421Tp31ruDWCbTmSEkGCe5CP9H8ROp07JR6C6XZKPYLfQtgtCJcBD4g2I/45sjwFDKGYiO3KkJ/nIyso67KI3+cg11+z3FtJVPzgGTbQvfRzEf9m/14AhFDORNXLokCH5CPy/F40cPNiffOTuu1e8hXTVD45Blw07ZQ6xBs6R4oeHFhhC6SKyLX3q4CMfXPaOEpCPFC08tMAQiieyIVU/OAY/Uszw0AJDKILIfPHFF192bvHp4AZLYDU4Bj9SzPDQAkMonsiGVP3gGPxIMcNDCwyhWInsmWcura4ako+sra2fOvUCbHnsWFfykZWVk95CNtUPjsGPFDM8tMAQipnIjh/vST6yulrCLrqTjxw7dtxbyKj6wTH4kWKGhxYYQjEQ2dqaU/IR7pcRh+Qjil/mLbSnlIB8pGjhoQWGUAxE5p58hHfhknzEYKEqDw3BaJQVeUjSwtoAXkoLaTxlojaQe65AY6mB0s82qb6uaV3PspCQpFSuFomh0lUqpsCNS5VFYTaT9cP0VuXhXJCQL0i08ASwKg/F7J1loTyTu2SWhSQpNgNPlYdhXhkulUlTb21glyIlhJC+u7KQJgWtKxqGtKppEtKqWTVEDM1AZMQ5+Qhv75J8pGvqKAuvgkRmWZBVHpIoVIxUpCSMrPcWqViTRQq1IF3aLhFKKFIjI88//+YnsjJpbxQAqizi8IpkHlRomQI5PJnI+MY2EJHZZA7+4lKkLrt1S2Tt41o6q+XZaCYyx+QjvL1L8hGzhYSd5iCyNOPuAx9Y1nEvN6rBulUW9e4MmytACRptGahtg3Nrrttld4z3UCZwA9i4ltAyBXJ4EpGFeZY0VhBEVmXtfyiBq6CuwaUwTfhUL9h/ixGESNTbhRvOFlGYJiEhJC0awhI1TT+sk/ZSXumoqjxM0kR6NBNIZAX7zxYJHwIlhJKQJsAjS8K2suolsqUlp+QjS0sZ78Il+UjX1JmXyAppNyiTpqaXyIzdSt779k5TLZAsEjC3CvDfipo2cHpJk4/ZtRkgu1F2PDu6gls94HqJvACpzTVShIIWnkJkVRvaMzOJaawZRVoFbM4zI7brX5AIdMMBRSaltCg4BsL5VO5ZNJB7k2q0IKmdh9DPYrRFaFG3P0Ro6e6R1bVT8hGobpfkI11Tp4vItMJXoLL2GqV0EBl3c8xuxWLR3CLTtFZcMDgvASoe//LZqTRQ9NYoSvTc15WqMbDZypUb1RJapkAOTyWymhZJlFVszgN3Rgn5KxCpCNoCJcxmYnHxHVQPEmGN8MjamvYpCpHpqMQtWlDMG3N3jFBCaJjRKqNhRlk/8xKZS/IRqG6X5CNdU2dujwzYTGit97AfIZFZPSAFIWefzrEoG6lBh5auJDJtvUJ4RlYr3uI8I0UnaOHpRFZXeZjkcxKZ8TSKLRPFa1OfW289kSUSsM0hMpfkI1DdLslHuqbOAkTG1MS81g3dK8k8QdPmTFM2LRqjqkwhMbLiq1uO9uAA1d/WriROtJ2ReSIbBJgcGGq2s4eWfHvWQkI+34BNtcNQI5HNEVr2EllFQ0KbS+IdZRNa1jSZO7R0ST4C1e2SfKRr6ixCZI2+CqDN3nvRHfaDERlUAcPMTvYx6lNSSGdXtt+eyAYHphAKPMni/pR8L7sE3uyrh/0NJ8qnB4bDft0jg4f9tP3myXTYL44seomsth/2Exoqn184HvbXtVPyEahul+QjXVNnISJr7aG+busiMmSfX7Qyy0IShpEUAoBwz7QVU+2MzE5PvV1J3c6y0Bha+jOyvQ1MDz8XEbfPL2ziFFr2Jh+B6nZJPtJloQ0d9hP5LKyWaciRyGrKvp4F+8/2imGaKvRaU/kdeWl+62p7a6nqtrcrmaREt5Di/VvLvQ1s04mMEBLOk3yk/4PYunZKPgLV7ZJ8BLuFtl0QKqGSv8sziP+OzANDKWYiW13tST6ytrYOu+hNPrJv335vIV31g2PQRPvSRxb/Zb8HhlPMRNbI0aOG5CPw/140srzcn3zkvvtWvIV01Q+OQZcup2zesALnSPHDQwsMoXQR2ZY+dfCRDy57RwnIR4oWHlpgCMUT2ZCqHxyDHylmeGiBIRRBZL744osvO7f4dHCDJbAaHIMfKWZ4aIEhFE9kQ6p+cAx+pJjhoQWGUKxEVlWXjhwxJB9ZWVk/efIF2PLw4a7kIw88cNJbyKb6wTH4kWKGhxYYQjET2UMP9SQfOXKkhF10Jx85fPi4t5BR9YNj8CPFDA8tMIRiILKVFafkI9wvIw7JRxS/zFtoTykB+UjRwkMLDKEYiMw9+QjvwiX5iNlCkzyQQ9FgNAOX0nF7y2wE28Wl8V5CCCHRaMIeNE6lP9kt4hHqU+Q+49LcxtjzXKrvV4K76CAXuH0yiloMEFuQT8w3MoWNWU1cwjbIFyRaePIM4fNtNgrc595sFDC7LCiTPDBOgGkZN/XWBnYZp9Z5BWQU0HhMpxMaBHQypXFAJ4wQ+NAMREack4/w9i7JR+wWgsuvjPkyBpfGMaCVZgxwqZjX8GwUkDhOtZaEqMzF/hynRKFOwZiwf1PPi05TixK2TSQMZQx10jXMMuaTCZD7OJYWD1qmQA5P3epaQwxEZDaZg7+49MyuVloiax/X0tlUnmZmInNMPsLbuyQfsVtId3bSsXSpjA2OlYWMlEpTyxF3N9SnyCbn26DxcQt6QI5K2DYBGCZAP+O4k1LHKdhOwZqR6vEyBXJ40gwJ8lHcrAJBZJNRZHPh20tBGkOjSKGGiHLk5dAUtgaDNA4IaSZ8kE9ETdMP66S9lE90VJM8iNNYiXL4/OE1Y/afLWI+BEoIJQGNgUcWB23lpJfIDhxwSj5y4EDGu3BJPmK1kLpiGW2JS5oLpoiJUyajqLlFWopty9koYO35vR3coYVdhp4XnKY2JbS/wdxSJxwI6IC64hFrEJeisZg04D+4q14n3PA3tPnDnUDae9AyBXJ4CpFN2pidGcVlp5/kQWMU4De161+QCHfART/tJIchLcdAOJ/KPYsGcm9SjbZht9MP+lmMtggdT9sfIrR098imU6fkI1DdLslHrBZS1zBQkBTsyAsPSjcRQO8A0paygGUnwt6/pecFp6lNCcDNmYwi9jhAGdKUBbwPWhI+z1rkpnjQ0E872KBlwR5GA/CoEtGgZQrk8FQim9JxHI0mjMiAO6PE8opP3dIWKMFoZtje9CAR1giPrK1pn6IQmY5K3KLti7wxd8cIJYQGIzoZ0WBEWT/zEplL8hGobpfkI1YLOREZl9LgoxpDM2ES07LXtzVHIrP1vOA0dWVzNoN1qIpHNpb7UX9DfWp64E+Uzpi17RTIZBQp/ix0V9EyBXJ4OpFNJ3kQ53MSmTGmYXSmeG3qc6dbT2SxBGxziMwl+QhUt0vyEauF+kNLo/aBRkyH8WrRj+0bR31joaW95wWnaZcSYIlGE8X3MYPsITKpW0dC1+IXsGx0f80T2WYCkwND1WRdh8hsr9VCQn5CAoylRRtGIpsjtOwlsgkNCG0uiXeUTWg5pfHcoaVL8hGobpfkI1YL9R72GyhGdi56z/4tx/bjuDlLshz2S5NAD7vknhecpv1vPOSrixCZ6md1hJaKNgwj1X0xeW3II0UpaOEZiQyajx+r62EBuxQF1sP+hhObUBN23hR+2K97ZPCwn4rjC+2wX+yavUQ2tR/2Exoon184HvZPp07JR6C6XZKPWC3U//kFPPRhRoIrWaMn3Utq15WB8ghfh7JnAR7K7urqecFpav38QnGjNM41cHQfkYGNwbC9K3E0dGDN7GnkcX9GtkuBGafB3OL2+YVNnELL3uQjUN0uyUfMFlJDJ6ufJXYPon1BZzuMV1Rm+mZCdSj013mi/86eN24GJyW0IwIxoHaL+a1lV2gJ37uX2mGcxEF8dyWyLRqelYwiIfdvLXcpsE0nMkJIME/ykf4PYqdTp+QjUN0uyUewW2jbBa0S4FGxWSZ53N3Af0e2q4EhFDORHTnSk3xkZWUddtGbfOSaa/Z7C+mqHxyDRbpeUE6ndDJKu48F/Zf9uxsYQjETWSOHDhmSj8D/e9HIwYP9yUfuvnvFW0hX/eAYbNLvlHWIFn1gHilmeGiBIZQuItvSpw4+8sFl7ygB+UjRwkMLDKF4IhtS9YNj8CPFDA8tMIQiiMwXX3zxZecWnw5usARWg2PwI8UMDy0whOKJbEjVD47BjxQzPLTAEIqVyJ555tLqqiH5yNra+qlTL8CWx451JR9ZWTnpLWRT/eAY/Egxw0MLDKGYiez48Z7kI6urJeyiO/nIsWPHvYWMqh8cgx8pZnhogSEUA5GtrSok5K4AAA/+SURBVDklH+F+GXFIPqL4Zd5Ce0oJyEeKFh5aYAjFQGTuyUd4Fy7JR7osVOUhj0WTUkVZpIREWaW0TwvjkGBXsI1UL1/Ve9OfWNO6nmWwCx3nxlVvwxZmsw132KGTjd9eZRHDIEZtRgXAJwWrkZWDfEGihSfPED4hZ1moT06bzLKQ2WVBqfIwzCvDpTJp6q0N7FKkhBDSd1cW0qSgdUXDkFY1TUJasWnJh2YgMuKcfIS3d0k+Yp06RQoYZ5aFCkfMspAkSSpV2hZtkcKxSXyk3VIkTIPqJdMTm/aiRse54DSFAMpkPi5bRCQMZcJ+y1rS10+ZcIUDbReJtHjQMgVyeOpW1863gYjMJnPwF5dCXWVGaYmsfVxLZ7U8zcxE5ph8hLd3ST5ithBcCcJmwE7NAlOWupnIDDarssjCVqDG2LmBXJy9QjexE5lC7tsiAANwx7RR6xNRTGKgf6keL1MghyfNkDDPksYWgsiqLLI5y+2lME2gUaRgwuRrC/+aLY0wTUJCmhUR5pWoafphnbSX8kpHVeVhkibGOAYSWcH+s0XCh0AJoSSkCfDIkrCtrHqJbGnJKfnI0lLGu3BJPmK2UN+KrbKoGWqRKOrW7rJWRlm1ASIzP3EzXLCuaaoihwxSJp2Rsgjo2gazLCRJxhokpWgsJg34b0VNpXS71Y3tFLgnSQyIlimQw1OIrGpjdmYgYR37LlvlYWMU4De161+QCHfART/tKoBeBcdAOJ/KPYsGcm9SjbZht9MP+lmMtggt6vaHCC3dPbK6dko+AtXtknzEbCF569YEWAi2NC4wc1dsdRlDS3UN25/IuiIKI2zWNFWHw70b4eYI7xJShoGOZ1lIYEstNjTFg0ZaL1IS5gXbYLsjFACPKt4xWqZADk8lspoWSZRVjMiAO6PE8sCnBrQFSpjNDNubHiTCGuGRtTXtUxQi01GJW7SgmDfm7hihhNAwo1VGw4yyfuYlMpfkI1DdLslHzBbqJjLpqmn1WhtzgURGVFvWWm+2J2p9Lk5nTkRmJFnjSBWPrJD7UX/DschEBn3kIhWKMr8AESuHaPsE1zBapkAOTyeyusrDJJ+TyIzTla0LxWtTn1tvPZElErDNITKX5CNQ3S7JR8wW6got5beE5jhIMYnele7fAn9bvdH+RPMMcD9z7ZumttBS5d8oqxTfxzyKHiKTutWIjHduOwKTpcoineM8kW0mMDkwVE3WdYALN3IpJORHKMBYWjhiJLI5QsteIqtoSGhzSbyjbELLmiZzh5YuyUegul2Sj1imju71WIPBrgOvmm7ssN/4QrPjiQbCXfR9UBeR8ce5+57uRCZRsEb0KuNLL5T18eq+mLw2FHNjFLTwjEQGzVfZo352KQqth/0NJzbhCey8KfywX/fI4GE/FccX2mG/2DV7iay2H/YTGiqfXzge9te1U/IRqG6X5CO2qSPv5+J8R/7cgXLVs/B+8z+/6HqidPDEYM/91lmfptbPLxQ3St5m4bR2JzJAyobtXQYj+MjoO1vdUn9GtkuB6eHnIuL2+YVNnELL3uQjUN0uyUe6LKS/RLO9+G+WU8eBFzyS7/lio0wIf6mXFt1PZIoDj1zUnDKRSUV3UZvdVf4qRW68gdASvncvtcM4xfMSjXklZzdJIVIb/9ZylwLbdCIjhITzJB/p/yC2rp2Sj0B1uyQfwW6hbRe0SoBHxWap8qS7gf+ObFcDQyhmIltd7Uk+sra2DrvoTT6yb99+byFd9YNjsIj2vY8sVZZ2v+XwX/bvbmAIxUxkjRw9akg+Av/vRSPLy/3JR+67b8VbSFf94Bhs0u+UdYgWfWAeKWZ4aIEhlC4i29KnDj7ywWXvKAH5SNHCQwsMoXgiG1L1g2PwI8UMDy0whCKIzBdffPFl5xafDm6wBFaDY/AjxQwPLTCE4olsSNUPjsGPFDM8tMAQipXIqurSkSOG5CMrK+snT74AWx4+3JV85IEHTnoL2VQ/OAY/Uszw0AJDKGYie+ihnuQjR46UsIvu5COHDx/3FjKqfnAMfqSY4aEFhlAMRLay4pR8hPtlxCH5iOKXeQvtKSUgHylaeGiBIRQDkbknH+FduCQfMVtokgckHUNMkzwgJB63P4hydVrGvNJ8r9Ier8hKkEowmm24wwXHLt8+GUUSho7OAfh4zGriErZBviDRwpNnSDSaNPWzUcB/98psFDC7LCiTPAjyieFSGTf11gZ2GaeEENJ31yig8ZhOJzQI6GRK44BOprNRAKackciIc/IR3t4l+YjdQmCFQINN8oBEgWKGcUqCKNiFRAZhl/F8XLaISBjKWFbjONZ3FAG1NdA4Jcx241iyGlqmQA5P3era7WEgIrPJHPzFZZwSec8zSktk7eNaOpvK08xMZI7JR3h7l+QjdgvB9QMsNMkDko5k12Ack3iU73Yia0hhewcCMKjuGNw8FBmnYDsFa0aqx8sUyOFJMyTIR3GzOgSRTUaRzYVvLwVpDI3Ses6cELUIQPjXbIkFaRwQQtJxQ1iipumHddJeyic6qkkexGksPRrMH14zZv/ZIuZDoIRQEtAYeGRx0FZOeonswAGn5CMHDmS8C5fkI1YLtSsE7O3wksT3ZdzU7Hoikzi9jOHcUiccCOjaBrNR0NA9mzoT8JtPIF6aSul2uOHPRgHQeZdAC0p7ElqmQA5PIbJJG7MzA0lrR/bRpDXCDmrYOmrXvyAR7oCLfiajiM0cECE1GAjnU7ln0UDuTarRNux2+kE/i9EWoeNp+0OElu4e2XTqlHwEqtsl+YjVQiQdN7yusLW4xFTZDFs2klZ2B5Fx70a4OZNRxNwcQBkGWp+NAgJbEj7P2iloigct20PrnTkQGYBHlYgGLVMgh6cS2ZSO42g0YSsCuDNKLA99akFboDCbytubHiTCGuGRtTVibkAi01GJW7SgmDfm7hihhNBgRCcjGowo62deInNJPgLV7ZJ8xGohEgUBIXE+CojxgJlbRehl93tkYLvTQ285cNM6gSRi+81F2zalqBac43YqdjKKlC1kHAtromUK5PB0IptO8iDO5yQy42kUozPFa1OfO916IoslYJtDZC7JR6C6XZKPWC0kORfqGdlYaJP5pXuCyCC/wBKNJorvo4/dgcikbjUiU2KQPsVORhEh6vGzJ7LNBCYHhqrJOkJL7n1rIWEbPErGAv0008BIZHOElr1ENqEBoc0l8Y6yCS2nNJ47tHRJPgLV7ZJ8xGohOZARG7uikTHQ164nMu4WGUe0oEcmbRiaRyavAaXo7790X0xeG/JIUQpaeEYig+bjx+oWuxAC3/urh/0NJzahJuwcHNGYPTJ42E/F8YV22C92wV4im9oP+wkNlM8vHA/7p1On5CNQ3S7JR6wWkpYBOCwDlxqNi5cgu5zI4OcXihulvRjh09qdyEDwaNjejTq0KVZxomU7+jOyXQhMDz8XEbfPL2ziFFr2Jh+B6nZJPmK2kJmMiHSoP5W+UdqlRNbh+HDPSIm75cYbCC3he/dSO4wzHaXJiuXe1ljz2fxby10ObNOJjBASzJN8pP+D2OnUKfkIVLdL8hHsFtp2QasE9TsyXSZ53N3Af0e2q4EhFDORHTnSk3xkZWUddtGbfOSaa/Z7C+mqHxyDRbTvfWSZjNLuL8v9l/27GxhCMRNZI4cOGZKPwP970cjBg/3JR+6+e8VbSFf94Bhs0u+UdYgWfWAeKWZ4aIEhlC4i29KnDj7ywWXvKAH5SNHCQwsMoXgiG1L1g2PwI8UMDy0whCKIzBdffPFl5xafDm6wBFaDY/AjxQwPLTCE4olsSNUPjsGPFDM8tMAQipXInnnm0uqqIfnI2tr6qVMvwJbHjnUlH1lZOektZFP94Bj8SDHDQwsMoZiJ7PjxnuQjq6sl7KI7+cixY8e9hYyqHxyDHylmeGiBIRQDka2tOSUf4X4ZcUg+ovhl3kJ7SgnIR4oWHlpgCMVAZO7JR3gXLslHzBaq8lCLRpPCXE9IWvBOYIOkBJWgjbGmSAmJsgqF6m1KCLPZ4PC2ZKQoBS08eYbwSTvLQvcJPMtCkhSbgafKwzCvDJfKpKm3NrBLkRJCSN9dWUiTgtYVDUNa1TQJaVXPspBxBdOVSmTEOfkIb++SfMRuIZlouuvF+PnVWRYyLusnslkWkiRJBfcNJ3YllEk3l3UrB5+gZQrk8NStrp20AxGZTebgLy6F00psiax9XEtndU2LpI/IHJOP8PYuyUfsFtookZUJkW3D96teImv+xEEEXUqQmHpDysEoaJkCOTxphoR5ljT8JYisyiKbC99eCtOEE1nB/h+ZIEQtAhDBQVq0z02TkJBm1YR5JWqaflgn7aW80lFVeZikiRI81QwSrynYf7ZI+BAoIZSENAEeWRK2lVUvkS0tOSUfWVrKeBcuyUesFtookXUs8j4iq7KoUVyRDB++dSqhTHgoUYD/tp6UDY8TQkCAzGuQshtapkAOTyGyqsrDljuUbRvMFt6eMxE/q2F+U7v+BYmUidZPu1JgSMsxEM6ncs+igdybVKNt2G0sBf0sRluEFnX7Q4SW7h5ZXTslH4Hqdkk+YrWQfDwEgkStNJeK1BpU95ysyewwtz+8FdNU5SAeEQD3k5/uSe1F7FBl0eCD6hkpSkELTyWymhZJlFWMyIA7A5d0XdMqi/g+LWgLlDCbicUCj5iV+QNrhEfW1rRPUYhMRyVu0YJi3pi7Y4QSQsOMVhkNM8r6mZfIXJKPQHW7JB+xWmgOj6yLyOwemXSjFp8OO02tRAZF3+KUe7WdGYegZQrk8HQiq6s8TPI5icx4GsXoTPHa1OfWW09kiQRsc4jMJfkIVLdL8hGrhbYptBQnAqqLh2GadoSWkptpJDJYPJHtHngGIqtpkejTwB5a8g1bCwn5MUstTlq0kMVIZHOElr1EVtGQ0OaSeEfZhJY1TeYOLV2Sj0B1uyQfsVpo8cN+yVoWIjNfGnLZdymBk7UEstcjQypomQI5PCORwSnBj9X12IJdikLrYX/DiU2oCTsHBzJmjwwe9tP2iNZ02N8+14XIavthP6Gh8vmF42F/XTslH4Hqdkk+YrXQxj+/qLKISJ/VMEvYiaxIDP7XsEf+diWAzy+A+ylvxdLwxYxBSWpomQI5PIzAFvnYQhe3zy9s4hRa9iYfgep2ST5itlAXkRmK2HnUd3mW3toay+FR91cOWyzE/sYDbLDwHXnJOEv5GlB/j4lLMC7InQAPI7BNJzJCSDhP8pH+D2Lr2in5CFS3S/IR7Bbadtk7SkA+UrTw0AJDKGYiW13tST6ytrYOu+hNPrJv335vIV31g2PwI8UMDy0whGImskaOHjUkH4H/96KR5eX+5CP33bfiLaSrfnAMfqSY4aEFhlC6iGxLnzr4yAeXvaME5CNFCw8tMITiiWxI1Q+OwY8UMzy0wBCKIDJffPHFl51bWiKjvvjiiy87vHgi88UXX3Z88UTmiy++7Pjy/wEc2jcUcjMGPgAAAABJRU5ErkJggg==)
La función lo que hace es comparar una fecha con su anterior y devuelve la mayor diferencia entre dos fechas:
Código:
CREATE DEFINER=`root`@`localhost` FUNCTION `dias_sin`() RETURNS smallint(6)
BEGIN
DECLARE resultado SMALLINT DEFAULT 0;
SELECT MAX(DATEDIFF(dt1.fecha, dt2.fecha)) INTO resultado FROM datos dt1
INNER JOIN datos dt2 ON dt1.salida_num = dt2.salida_num + 1;
RETURN resultado;
END
Espero que os lo haya aclarado más, y siento el malentendido. Saludos.