Hi all,

i use actual delivery date minus plan delivery date,
(tdpur406.ddte - tdpur401.ddta )

i only want date count,time ont join

have what means time(2008-05-09 23:59) Conversion (2008-05-09 00:00)

pls help me

or delete time

hi plz convert the dates into local time with "utc.to.local" function.after getting values substract and convert to utc.to.local. it'll work. all the best.

Pls Help me. UP

You have to convert the utc values to date values:

utc.to.date(tdpur406.ddte, year1, month1, day1, dummy, dummy, dummy)
utc.to.date(tdpur401.ddta, year2, month2, day2, dummy, dummy, dummy)

Now calculate the days:

date.to.num(year1, month1, day1) - date.to.num(year2, month2, day2)

HI wiggum, Thanks for you help! OK!