Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a date field(ClaimDate). I need to calculate the age of claims. I have acheived it by using below expression.
=TimeStamp(Now()-ClaimDate,'hh:mm')
Can I use Age function in this secenerio?
You may use
Interval(Now()-ClaimDate,'hh:mm')
Hi
Thanks for your fast reply.
In either cases, my Dashboard is getting refreshed frequently. Dashboard contains more records.
Hi Kriamam,
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.
Regards,
Gab
Hi gabsus
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.
Hi,
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.
Regards,
Cesar
You can use a format code that includes the days, check out the format codes section in the HELP:
=Interval(Now()-ClaimDate,'dd hh:mm')
Hi,
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
Regards,
Gab