Re: OW Dates in Crystal Reports

nbandi

Member
Re: OW Dates in Crystal Reports

Hi:

If you can use the following formula that I wrote for my VB Application to read
dates from AS400 (Julian) you should be able to read your OW dates!
DateSerial(1900 + Int(JulianDate / 1000), 1, JulianDate Mod 1000)... Here the
JulianDate would be your OW Date.
However, you have to use a different formula to convert the time from numeric
format!

Niranjan





[email protected] on 03/13/2001 11:14:21 AM

Please respond to [email protected]

To: [email protected]
cc: (bcc: Niranjan Bandi/HOFFMAN/PENTAIR/US)
Subject: OW Dates in Crystal Reports



Do any of you use Crystal Reports with Oneworld data? I'm having a problem
converting OW dates. The only successful function I could build is shown

DateAdd ("y",
ToNumber (Right (ToText ({OWDATEFIELD}),6)),
DateAdd ("yyyy",ToNumber (Left (ToText
({OWDATEFIELD}),3)),Date(1899,12,31)))

Does anyone have a better solution?
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
 
RE: OW Dates in Crystal Reports

We use Crystal Reports and do some reporting on dates. Do you use the ODA
driver? This driver converts all the OneWorld data into readable form for
3rd party reporting tools. If you are using ODA then you are going to have
to describe the problem better.
Greg

Greg Cotten
Information Technology
Virginia International Terminals
391-6187
 
Re: RE: OW Dates in Crystal Reports

If he's not using ODA then another solution is to do all the reporting off of Database views that have virtual or fomula fields for dates (ditto for decimal fields).



Larry Jones
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE
 
Back
Top