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
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 13th June 2013, 10:28
berthier berthier is offline
Junior Member
 
Join Date: Jun 2013
Posts: 6
berthier is on a distinguished road
Baan: Baan ERP, LN6 - DB: Oracle, SQLSERVER - OS: Windows, unix
Incorrect Date Format on report
Baan: ERP LN 6.1 FP7
C/S: None/Unknown

Hello,
Sometimes I get an incorrect Date Format in report using %u001, %u002 or %u003 in report fields. The field is in utc date time (tcdate) an instead of editing the date with the format '05.29.2013', the date is printed like 'May%x05'.
Thanks in advance for any help
Reply With Quote
Sponsored Links
  #2  
Old 13th June 2013, 11:47
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,286
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Refer this from Standard Doc!

This is from the Prog. Guide.

Dates
| Suppose date format 002 is: "year/month/day in month"

string result(80)

result = sprintf$("%D002", 727168)

| result contains "1991/12/2"

| Example of substitution symbol %D(format)

string result(80)

result = sprintf$("%D(Date: %02d/%02m/%04Y)", date.num())

| result contains "Date: 12/07/1993"

result = sprintf$("Date: %D(%02d %-20H %04Y)", date.num())

| result contains "Date: 12 June 1993"

UTC dates and times
| Date format 002 is "year/month/day in month"

| Time format 001 is "12 hour format:minutes:seconds AM/PM symbol"

string result(80)

result = sprintf$("%u002 %001", utc.num(), utc.num())

| Result contains "1997/01/01 10:02:53 pm"

string result(80)

result = sprintf$("UTC: %u(%02d/%02m/%04Y) %U(%02h%x%02m%x%02s %a)", utc.num(), utc.num())

| result contains "UTC: 22/07/1997 06:24:53 am"

| provided that for the user's language the time

| separator is ":" and the AM symbol is "am"

| Using a comma after a %u substitution symbol

string result(80)

result = sprintf$("%u001, ,Message text....", utc.now())

| result containts "06-05-15,Message text...."
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #3  
Old 13th June 2013, 13:47
mpenno's Avatar
mpenno mpenno is offline
Member
 
Join Date: Feb 2002
Location: Italy - Turin
Posts: 49
mpenno is on a distinguished road
Baan: BaanIV / BaanERP / LN - DB: Bisam / Oracle / SQLServer - OS: Aix / Sun / HP / Linux / Windows
We have the same problem with our customer.
We have opened an incident to INFOR.
The answer is:
"We have identified that on Windows environments the runtimefile "datecurr" sometimes, for some reason, is not read correctly.
We have been working hard to identify and are currently testing a new nbshell.
We hope to deliever a solution for this with the next portingsetrelease, scheduled for the beginning of July."

As soon as possible, I will let you know news.

Bye

Max
Reply With Quote
  #4  
Old 13th June 2013, 16:54
berthier berthier is offline
Junior Member
 
Join Date: Jun 2013
Posts: 6
berthier is on a distinguished road
Baan: Baan ERP, LN6 - DB: Oracle, SQLSERVER - OS: Windows, unix
Ok, thank you very much for your answer, and let me know as soon as you get any solution.
Bye,
Philippe.
Reply With Quote
  #5  
Old 19th November 2015, 16:24
BOBBYLYON BOBBYLYON is offline
Member
 
Join Date: Jun 2008
Posts: 53
BOBBYLYON is on a distinguished road
Baan: ERP LN - DB: ORACLE - OS: WINDOWS SERVER
Hello,

We are experiencing the same problem with date format (e.g. November%x11) displayed in reports.

Would you have the solution by now ..? :-)

Thank you for your help

Merci from France


Bertrand
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
Incorrect Date Format in report berthier Blogs and Web links 0 12th June 2013 11:14
Simple Report Script Date chris_kzn Tools Development 14 29th May 2013 16:19
Multiple date formats & currency formats by user. kphipps Tools Administration & Installation 6 9th November 2005 14:19
solving recursion problems rmarles Tools Development 2 25th January 2005 21:23


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


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