Hi Baan Friends

I wants to calculate difference between two dates inputed by user
like 15/07/2007 to 20/07/2007 (DD/MM/YYYY) then how can I get the
difference as no. of days = 5

Thanks & reagards
Sumesh

Hi,

Use function inputstr.to.date(date2,format) - inputstr.to.date( date1,format).

Match the format with the one in your system.

Bye

go to
http://www.baanboard.com/baanboard/showthread.php?s=&threadid=9832


You will be able to find the solution for your problem.

Hi Baan Friends

I wants to calculate difference between two dates inputed by user
like 15/07/2007 to 20/07/2007 (DD/MM/YYYY) then how can I get the
difference as no. of days = 5

Thanks & reagards
Sumesh
Hello Sumesh
If I understood your question, I think I can help you:
Dates in Baan are stored as long number since 1-1-0001, so if you make arithmetical operation between dates, as a result you will obtain a long number.

ex:
long diff.c
domain tcdate date.from | 15-7
domain tcdate date.to | 20-7

diff.c = date.to - date.from


Good Luck, and best regards
Rodolfo

Thanks,
That is what i was looking for!!!!!