Discussion Board for collaboration on QlikView Scripting.
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
Go to Solution.
And this ?
Year(Today())*12+Month(Today()) - (Year([Emp joined date])*12+Month([Emp joined date]))
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.