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
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
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
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +