Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
Would you like to see a separate forum on Baanboard for the ION product?
No
14%
Yes
86%
Total votes: 80

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 21st June 2012, 06:28
yogesh kapil yogesh kapil is offline
Member
 
Join Date: May 2012
Posts: 63
yogesh kapil is on a distinguished road
Baan: lnfp7 - DB: oracle11g - OS: linex
Date Subtract

hi,

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

Thanks and Regards
yogesh kapil
Reply With Quote
  #2  
Old 21st June 2012, 14:21
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Louisville, KY, USA
Posts: 5,943
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
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 that could probably help. A quick search just use date on the tool forum I am sure will turn up others.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.

Last edited by mark_h : 21st June 2012 at 14:23. Reason: Add link
Reply With Quote
  #3  
Old 22nd June 2012, 13:55
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,328
bdittmar is on a distinguished road
Baan: 2.2/3.1/4c4/LN6.1 FP6/HiDox - DB: bisam, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
Convert and calculate

Quote:
Originally Posted by yogesh kapil View Post
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
__________________
//Bernd
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Default Receipt date for EDI Purchase Orders Jason Patte Distribution, Transportation & Warehousing 0 7th April 2010 16:08
Different Date Formats in Different Companies Khushro Tools Administration & Installation 5 6th December 2002 22:47
Time phased inventory movement date noonie Manufacturing & Supply Chain 0 20th February 2002 22:51


All times are GMT +2. The time now is 19:32.


©2001-2013 - Baanboard.com - Baanforums.com