year & month Calculation formula in Table

[Pulkit]

Dear Friends

Greeting & Good Morning,


What is formula for year calculation in Table.

attached please find herewith Access file for your ready reference

 

[Eljefegeneo]

I think what you want is the DateDiff Function. Look it up.

 

[Pulkit]

yes Sir

can share formula.

my requirement is like

Suppose..

01/03/2010 and second date is 01/06/2015

different of both date is 5 year and 3 month

i want result of both date as how many year & How many Month.

result should be 5 year and 3 month

 

[Brianwarnock]

It is not normal to store calculated fields in a table, the calculation should be done in the form or report when required.
There is no simple formula to do what you want but there are code samples in the code repository, one such is here

http://www.access-programmers.co.uk/forums/showthread.php?t=221718&highlight=Date

Brian