RSZ-EC
Member
Hi everybody!
As I'm the first here and this is the first post I should congratulate the authors for this great software!
Now to my problem: When I use 'Period' field in an object to calculate the age of a person, the result I get is useful for me, because I only need years and months. But when I need to calculate the amount of days between two specific dates for specific uses (for example medical or legal certifications), I need that the 'Period' field includes the initial day in the calculation. So, if I choose a period from 01/01/2019 to 02/01/2019 (dd/mm/yyyy format) the result should return "2 days" instead of "1 day".
Is there a way to select this behavior in 'Period' field? Or a workaround for this?
In the meantime, I'm using A LOT of "[String([Period]=n day?n + 1 days: )] formulas in a 'Composite' field that check a 'Period field', and according to the result, returns a specific value. But it's not an elegant solution and only checks the amount of formulas I put in the field. For only 30 days is EXTREMELY long.
What can I do?
Thanks in advance!
As I'm the first here and this is the first post I should congratulate the authors for this great software!
Now to my problem: When I use 'Period' field in an object to calculate the age of a person, the result I get is useful for me, because I only need years and months. But when I need to calculate the amount of days between two specific dates for specific uses (for example medical or legal certifications), I need that the 'Period' field includes the initial day in the calculation. So, if I choose a period from 01/01/2019 to 02/01/2019 (dd/mm/yyyy format) the result should return "2 days" instead of "1 day".
Is there a way to select this behavior in 'Period' field? Or a workaround for this?
In the meantime, I'm using A LOT of "[String([Period]=n day?n + 1 days: )] formulas in a 'Composite' field that check a 'Period field', and according to the result, returns a specific value. But it's not an elegant solution and only checks the amount of formulas I put in the field. For only 30 days is EXTREMELY long.
What can I do?
Thanks in advance!