Hi Expert How To Calculate Date 15/01/06 - 05/05/05

mootoon

I want put code that calculate date START DATE - END DATE = ?.
Who knows the way to code.

JedrzejT

Hi.

Maybe i don'y understand ..but:
if startdate and enddate is type date then:

startdate - enddate = integer
15/01/06-10/01/06=5

If you take enddate from Data Record:

startdate - NORMALDATE(enddate)

Regards

mootoon

FOR EXAMPLE
I get DUE DATE = 15/05/05
TODAY = 17/01/06
TODAY - DUE DATE = 154
I want to know the code that calculate TODAY - DUE DATE = INTEGER

JedrzejT

Code to calculate TODAY- DUEDATE is :

"Int:=TODAY - DUEDATE;"

Variable:

Int = integer
Today = date
Duedate = date

Like i said:

Date-date=integer
Date+date=error
date+integer=date
date-integer=date

if your date is in text type variable then
duedate:=DMY2DATE(15,5,5);
or use EVALUATE function

mootoon

Thank you

tammakit

You can use DURATION type

// from C/SIDE Reference Guide
DURATION
Use this data type to represent the difference between two datetimes, in milliseconds. This value can be negative. It is a 64 bit integer.

DATETIME-DATETIME=DURATION

DATETIME-DURATION=DATETIME

DATETIME+DURATION=DATETIME