Calculating Differnce between dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In access in one field I have one date and in another field I have another
date. I want to calculate the number of years.,months and days elapsed
between these two date. e.g. suppose in one field I have 30.06.2005 and in
other 20.04.2004 then it should show 1 year 2 months and 10 days.
 
Hey,
Ex:
([DT FIM INTERRUPÇÃO]-[DT INI INTERRUPÇÃO])+1 AS DUR_INT,
IIf([M_12_INT]=12,[A_12_INT]+1,[A_12_INT]) AS A_INT, [DUR_INT]\365 AS
A_12_INT, ([DUR_INT] Mod 365)\30 AS M_12_INT, IIf([M_12_INT]=12,0,[M_12_INT])
AS M_INT, ([DUR_INT] Mod (365) Mod (30)) AS D_INT

its work

"ananga" escreveu:
 
Back
Top