Baanboard.com

Go Back   Baanboard.com > Forum > BB Language Forums > Deutsches Forum

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 14th November 2016, 13:17
MS-Tech MS-Tech is offline
Member
 
Join Date: Dec 2015
Posts: 66
MS-Tech is on a distinguished road
Baan: 6 - DB: SQL-Server - OS: Windows 7
Monat aus tcdate
Baan: Other/Unknown

Hallo Zusammen,

gibt es eine einfache Funktion, aus der ich z.B. den Monat, das Jahr etc aus einem tcdate extrahieren kann?

Viele Grüße
  #2  
Old 14th November 2016, 13:28
andreas.toepper andreas.toepper is offline
Senior Member
 
Join Date: Jun 2004
Posts: 127
andreas.toepper is on a distinguished road
Baan: Baan4, LN6.1 - DB: MSSQL - OS: Linux&Windows
Ich nutze utc.to.date(..) dafür:

utc.to.date()
Syntax:
function long utc.to.date (long utc, ref long yearno, ref long monthno, ref long month_dayno, ref long hours, ref long minutes, ref long seconds)

Description

This converts a UTC long format value to the corresponding year, month, day, and so on, in local time.

Arguments
long utc
ref long yearno
ref long monthno
ref long month_dayno
ref long hours
ref long minutes
ref long seconds
  #3  
Old 14th November 2016, 14:01
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,639
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
sprintf$()

Quote:
Originally Posted by MS-Tech View Post
Hallo Zusammen,

gibt es eine einfache Funktion, aus der ich z.B. den Monat, das Jahr etc aus einem tcdate extrahieren kann?

Viele Grüße
Hallo,
sprintf$()

Bsp.:

extern domain tcdate pdno.completed

dhlus500.year = val(sprintf$("%u(%04Y)",pdno.completed))
dhlus500.week = val(sprintf$("%u(%02W)",pdno.completed))
dhlus500.mont = val(sprintf$("%u(%02m)",pdno.completed))

Regards
__________________
//Bernd
  #4  
Old 14th November 2016, 16:15
MS-Tech MS-Tech is offline
Member
 
Join Date: Dec 2015
Posts: 66
MS-Tech is on a distinguished road
Baan: 6 - DB: SQL-Server - OS: Windows 7
Hallo Zusammen,

danke für die Antworten.

Viele Grüße
MS-Tech

Last edited by MS-Tech : 9th February 2017 at 15:07.
Sponsored Links
Closed Thread


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
leap year jojovalenton Tools Development 6 4th August 2016 10:02
Übergabe von Daten aus Baan IV an Email-Programm? Locher Deutsches Forum 4 15th June 2007 14:12
Drucken aus BaaN B-aa-N Deutsches Forum 6 27th July 2004 08:35
Formatproblem bei Excelübernahme aus 5.0c Kai's Forum Users Deutsches Forum 4 22nd February 2003 00:00
Lieferterminberechnung aus VK-Postion in 5.c Kai's Forum Users Deutsches Forum 5 27th June 2002 00:00


All times are GMT +2. The time now is 03:52.


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