970
Views
5
Solved
###### How to get the difference between two dates
Question

Is there any convenient ways to find out the difference between two dates? Toby Ng
Solution

hey, you can use this built-in logic function for this problem.

see this documentation for more: https://success.outsystems.com/Documentation/11/Reference/OutSystems_Language/Logic/Built-in_Functions/Date_and_Time#DiffDays Parko Cham

You may try the build-in function

such as

DiffDays(dt1, dt2)

example:

DiffDays(#1982-05-19#, #1982-05-21#)

output\: 2 Maria da Graça Peixoto In the build in functions Zameer Alam

We cannot use "-" in date format but if we need to find the difference between two dates we may use following equation.

```Concat("  Year = ",Concat(IntegerToText(Trunc(DiffDays(Person.DateOfBirth,CurrDate())/365)),

Concat(" , Month = ",Concat(IntegerToText(Trunc((365-((DiffDays(Person.DateOfBirth,CurrDate())/365- Trunc(DiffDays(Person.DateOfBirth,CurrDate())/365))*365))/12)),

Concat(" , Days = ",IntegerToText(Trunc((((365-((DiffDays(Person.DateOfBirth,CurrDate())/365- Trunc(DiffDays(Person.DateOfBirth,CurrDate())/365))*365))/12
)-Trunc((365-((DiffDays(Person.DateOfBirth,CurrDate())/365- Trunc(DiffDays(Person.DateOfBirth,CurrDate())/365))*365))/12
))*12))
)) )   ))```

Difference between Current date & DOB.png Zameer Alam

MY ISSUE WAS I WANT TO KNOW THE EXACT AGE , IF I AM HAVING BATE_OF_BIRTH

Yesterday I was searching for a solution for this issue but i did not find the answers suitable for my issue, hence i have tried it my own and yesterday itself posted that solution here but later on i find my solution need to be more precise and should be small so i have created new one for me kindly check if it solves your problem too,

``` If(Year(Person.DateOfDeath)<>1900,"He/she already passed away on "+Person.DateOfDeath,

Concat("Year = ",Concat(Year(CurrDate())-Year(Person.DateOfBirth),Concat(", Month = ",Concat(If((Month(CurrDate())-Month(Person.DateOfBirth))<0,12+(Month(CurrDate())-Month(Person.DateOfBirth)),Month(CurrDate())-Month(Person.DateOfBirth)),Concat(", Day = ",If((Day(CurrDate())-Day(Person.DateOfBirth))>0,(Day(CurrDate())-Day(Person.DateOfBirth)),(Day(Person.DateOfBirth))-(Day(CurrDate())))))))))```
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.