Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Code & Utilities

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

Reply
 
Thread Tools Display Modes
  #1  
Old 14th April 2003, 05:15
Ruskin's Avatar
Ruskin Ruskin is offline
Unconfirmed User
 
Join Date: Feb 2002
Location: New Zealand
Posts: 91
Ruskin is on a distinguished road
Baan: All - DB: MS-SQL, Informix, Oracle - OS: UNIX and NT Server
Using VB to Decode Dates <=> Longs

The attached text file is a simple way of using VB to convert a long to a date (either a UTC formatted long value, or a normal baan date long value). It also converts a date to a long (either the UTC long version of the given date, or a normal baan date converted to a long).

If the UTC date or long is used, the code will automatically convert the GMT date/time and apply the offset of the local PC. Thus, all UTC date/times that are converted, are done in the regional date/time of the PC.

These functions are very handy, when using OLE connections, so if you don't have your own date/time conversion functions. Also, when using the Baan 5 debugger, and clicking on a date value, only to get a meaningless long returned....


Hope this helps...

Ruskin.
Attached Files
File Type: txt date_conv.txt (8.2 KB, 277 views)
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 Off
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +2. The time now is 06:51.


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