Baanboard.com

Go Back   Baanboard.com > Forum > Local User Groups & Software > India

User login

Frontpage Sponsor

Main

Poll
Would you like to see a separate forum on Baanboard for the ION product?
No
13%
Yes
87%
Total votes: 90

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 19th June 2012, 12:13
yogesh kapil yogesh kapil is offline
Member
 
Join Date: May 2012
Posts: 70
yogesh kapil is on a distinguished road
Baan: lnfp7 - DB: oracle11g - OS: linex
two date difference
Baan: Other/Unknown

hi,

can you please help how can i subtract one date from another.

Thanks and Regards
yogesh kapil
Reply With Quote
Sponsored Links
  #2  
Old 21st June 2012, 23:19
Clecuyer's Avatar
Clecuyer Clecuyer is offline
Junior Member
 
Join Date: Feb 2011
Location: France (Eure 27)
Posts: 22
Clecuyer is on a distinguished road
Baan: BAA IV / V / ERP LN 6.1 FP5 - DB: Oracle / Slqserver - OS: TRU64 UNIX / Windows
sub date

hi ,

try this
long d1,d2,d3
d1=date.to.num(2012,06,21)
d2=date.to.num(2011,06,21)
d3=d1-d2

d3= Nbr of day between this two date

But the solution depend what kind of result you need !

bye.
__________________
Cdt
C.Lecuyer
Reply With Quote
  #3  
Old 7th August 2012, 13:15
ashish.k.gupta ashish.k.gupta is offline
Junior Member
 
Join Date: Nov 2010
Location: Hyderabad
Posts: 3
ashish.k.gupta is on a distinguished road
Baan: Baan LN - DB: oracle - OS: windows 7
You can try this also
usually you can subtract directly if both are having the same domain i.e. tfgld.dat or tcdate if not convert the date in same domain and then subtract
otherwise u can use this also
first get the year month day etc from date using
utc.to.date() and then
use utc.add(i.utc,-year,-month,-day,...)
but check which date is greater.
Reply With Quote
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
Difference in date shown in INFOR LN and database amitsdotcom Operating Systems & Databases 1 2nd November 2010 19:33
save difference between entered date and system date Andy.. Tools Development 3 27th April 2009 13:21
Remember date difference but not time difference in job parameters for utc-field en@frrom Tools Administration & Installation 0 11th February 2008 10:22
Date difference parames Tools Development 1 8th April 2003 12:20


All times are GMT +2. The time now is 14:05.


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