Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 17th February 2010, 12:27
greil.juergen greil.juergen is offline
Junior Member
 
Join Date: Aug 2005
Posts: 3
greil.juergen is on a distinguished road
Baan: Baan 4 - DB: Oracle 9i - OS: HP UX
Convert YYYY-MM-DD to Baan date in UNIX?

Hello,

does anyone know how to convert a date like 2010-02-17 to the correct Baan date 733820 in UNIX?

I've found a Windows utility which converts fine, but I can't use it automated in UNIX. Does anyone know a tool or command which helps me?
Reply With Quote
  #2  
Old 17th February 2010, 14:29
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,934
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
This is the correct forum - the code and utilities is for sharing code with others.

Are you talking in a session script?

Code:
| Parse out the last counting date
	      num.day = val(read.date(4;2))
	      num.month = val(read.date(1;2))
	      num.year = val(read.date(7;4))
	      upd.date = date.to.num(num.year, num.month, num.day)
__________________
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.
Reply With Quote
Sponsored Links
  #3  
Old 17th February 2010, 14:54
greil.juergen greil.juergen is offline
Junior Member
 
Join Date: Aug 2005
Posts: 3
greil.juergen is on a distinguished road
Baan: Baan 4 - DB: Oracle 9i - OS: HP UX
Hi, thanks for your answer.
I'm searching for a way to do that directly in UNIX (korn shell).
Reply With Quote
  #4  
Old 17th February 2010, 15:50
Juergen's Avatar
Juergen Juergen is offline
Guru
 
Join Date: Aug 2001
Location: Germany
Posts: 573
Juergen is on a distinguished road
Baan: IVc4, ERP LN - DB: Oracle - OS: Linux, Unix
Hi,

check the small unix dateplus tool on http://www.orlandokuntao.com/mf_nerd_dateplus.html

Regards,
Juergen
Reply With Quote
  #5  
Old 18th February 2010, 14:29
greil.juergen greil.juergen is offline
Junior Member
 
Join Date: Aug 2005
Posts: 3
greil.juergen is on a distinguished road
Baan: Baan 4 - DB: Oracle 9i - OS: HP UX
Hi Juergen,

thanks a lot for that link! Works fine
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
Application Support Analyst - India, Chennai Jothilingam Jobs and Resumes 1 27th March 2010 16:18
Collect purchase order / receipt date (Baan 5.0c) milorad.poluga Blogs and Web links 0 24th October 2009 15:18
Baan null date field view from oracle sql zaidlaz Tools Development 9 21st June 2006 18:13
Function to convert a VB date to Julian Date aldero AFS/DDC/OLE: Function servers 2 17th November 2003 10:39
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 20:44


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


©2001-2017 - Baanboard.com - Baanforums.com