Subject date non zero time substraction
Author Alejandro Garcia
Hi! I'm working with a date difference :
dif= F_IBABS (TABLE1.DATE1-TABLE2.DATE2)
If DATE1 and DATE2 are dd/mm/aaaa hh:mm:ss with
hh:mm:ss = 00:00:00 the dif value is an integer and works fine

But when hh:mm:ss are non zero in DATE2 the dif value I'm getting are with decimals and I need them to be as if the hh:mm:ss were zero like in the first case, I can't just round the result because it's obviously not the same.

Is there a way to update just the hh:mm:ss value in the TABLE2.DATE2 and make it 00:00:00? or how could I fix this?
Thanks in advance


---------------------------------

¬°Descubre una nueva forma de obtener respuestas a tus preguntas!
Entra en Yahoo! Respuestas.


[Non-text portions of this message have been removed]