Discussion Board for collaboration related to QlikView App Development.
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
And this ?
Year(Today())*12+Month(Today()) - (Year([Emp joined date])*12+Month([Emp joined date]))
View solution in original post
Try like this
Floor(Today()) - Floor([Emp joined date]) // Its give days not in month..
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
It was my requirement.
Thanks for your support.