Create a new field

[vardhancse]

Hi All,

I have a requirement is that,

one field: Emp joined date (MM/DD/YYYY)

Now I want to create a field :

That I should get the count in months i.e. (Today() - (Emp joiined date))

I am using the above mentioned expression, but was unable to get the data. Can any one please help me out in getting the same.

Thanks in advance

[MayilVahanan]

HI

Try like this

Floor(Today()) - Floor([Emp joined date])  // Its give days not in month..

[vardhancse]

Hi thanks for your reply/answer,

My requirement is that I want to display in months rather than in days.

Can you please help me out

[dvasseur · Accepted solution]

And this ?

Year(Today())*12+Month(Today()) - (Year([Emp joined date])*12+Month([Emp joined date]))

[vardhancse]

Hi David,

It was my requirement.

Thanks for your support.