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





wsellers@ftpayne.heilco.com on 03/13/2001 11:14:21 AM

Please respond to jdelist@jdelist.com

To: jdelistml@jdelist.com
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
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
 

gcotten

Active Member
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
 

Larry_Jones

Legendary Poster
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
ljones@wagstaff.com
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE
 
Top