i want to calculate the duration between two dates?

(0) Share

Report

Posted on by javedakhtar

1,751

i have a two data field ,FromDate,ToDate of data type Date.i want to calculate the duration between these two dates and want to assign the result to the Tenure field of datatype DateFormula.?

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (3)

Suggested answer

Jatin Patel 2,641 on at

Like (0)

Report

Hi Javed,

You need to declare one integer variable e.g. duration and then

duration = ToDate - FromDate;

it will gives you duration between two dates and you can use that value in dateformula field .

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

Hi,

FromDate - ToDate will give you the number of days between these two dates. In order to use that in the DateForumula, you may use the below example:

NewDate := CALCDATE(FORMAT(FromDate - ToDate) + 'D',TODAY)

In the above example, program will add the difference of two dates to TODAY.

Was this reply helpful? Yes No
Verified answer

4BzSoftware 6,073 on at

Like (0)

Report

Hi Javedakhtar,

EVALUATE(Tenure, '<' + FORMAT(ToDate - FromDate) + 'D>');

Was this reply helpful? Yes No
javedakhtar 1,751 on at

Like (0)

Report

Hi

i tried but it didnt worked out

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (0)

Report

Can you please let us know what did you try? and what didn't work? and how are you expecting it to work? with example

Was this reply helpful? Yes No
javedakhtar 1,751 on at

Like (0)

Report

HI

its working ,but there is minus sign with duration values;

fromDate=010515 todate :=150515

tenure:=-14D

Was this reply helpful? Yes No
Verified answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (1)

Report

use Todate first as it is bigger EVALUATE(Tenure, '<' + FORMAT(ToDate - FromDate) + 'D>');

Was this reply helpful? Yes No
javedakhtar 1,751 on at

Like (0)

Report

Thanks everyone its working

Was this reply helpful? Yes No
Verified answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (1)

Report

Javed,

You can also use ABS function to return it as positive

EVALULATE(Tenure,'<' + FORMAT(ABS(ToDate-FromDate)) + 'D>')

Was this reply helpful? Yes No
javedakhtar 1,751 on at

Like (0)

Report

Thanks Suresh Sir

Was this reply helpful? Yes No