yogesh kapil
21st June 2012, 07:28
hi,

can somebody please help how can i subtract one date from another. i am using lnfp7.

Thanks and Regards
yogesh kapil

mark_h
21st June 2012, 15:21
This is the correct forum for this type question. I am sure if you search this forum you will see many threads on that can help you.

Here is link (http://www.baanboard.com/baanboard/showthread.php?t=60011&highlight=utc+dates) that could probably help. A quick search just use date on the tool forum I am sure will turn up others.

bdittmar
22nd June 2012, 14:55
hi,

can somebody please help how can i subtract one date from another. i am using lnfp7.

Thanks and Regards
yogesh kapil

Hello,

as Mark suggest, SEARCH before post !

Extract the year,month,date from the utc date with utc.to.date(). Convert it to a date with date.to.num(). Do this for both utc dates. The difference between both results is the number of days.

Regards