I have a date field(ClaimDate). I need to calculate the age of claims. I have acheived it by using below expression.
Can I use Age function in this secenerio?
You may use
Thanks for your fast reply.
In either cases, my Dashboard is getting refreshed frequently. Dashboard contains more records.
I can't see any reason why you couldn't use Age() function to calculate age of the claim. Please follow this syntax
age(timestamp(Now()),date_of_birth (which in your case it will be CLAIM DATE)) meaning age(now(),claim_date)
Let me know if it works.
If I use age(timestamp(Now()),claimdate), I am getting data in list box as -1 and 0. My requirement is to display the age in days/Hours/Minutes.
Thanks in advance.
You cannot use the Age function since it will return only integer values for years. If you just use Now() - claimdate the result will be the difference in days. For hour and minutes you can use krishnamoorthy suggestion.
You can use a format code that includes the days, check out the format codes section in the HELP:
In that case what I will do is to use IF(age(now(),claim_date <0, age(now(),-claim_date,age(now(),claim_date)) this should give you right integer format.
Let me know if this is helpful or not
Retrieving data ...