Hi.. I need your help..
I'm using Baan 5.0c.
How to calculate the date, like the following illustration;
Formula:
day = delivery date - confirm. del date

Sample :
If Delivery date = 15 jul 2005
Confirm date = 17 jul 2005
The result is : -2 (days) -> early delivery.

It's simple but I've try using date conversion (date.num) but it's doesn't work.

Cheers..

Hi.. I need your help..
I'm using Baan 5.0c.
How to calculate the date, like the following illustration;
Formula:
day = delivery date - confirm. del date

Sample :
If Delivery date = 15 jul 2005
Confirm date = 17 jul 2005
The result is : -2 (days) -> early delivery.

It's simple but I've try using date conversion (date.num) but it's doesn't work.

Cheers..

Date conversation is [date.to.num] or [num.to date]

or [num.to.week] / [week.to.num]

Regards

Hi,

If the delivery date and confirm Date both are in utc Please try the following

ret1 = utc.to.local(deliverydate,deldays,deltime)
ret2 = utc.to.local(confirmdate,confdays,conftime)
result = deldays - confdays

Hope this helps you.

Hi,

Rita,
Thank's for your assist, it works now.

Thank's for all support....

Hi,

Most Welcome