We ended up using the formula builder for that, so here's the code we have. You could probably adapt the logic to javascript, but my advice would be to only use JS where you absolutely have to, since the development environment is so poor.
Inbound: ((year(BEG05) - 1900) * 1000) + dateDifference(stringToDate(0101 ++ year(BEG05)), BEG05) + 1 Outbound: date((SZADDJ mod 1000), 1, 1900 + substring(SZADDJ, 1, 3)) Regards, Philip Tillsley EDI Project Manager ~ Homax Products, Inc. ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of avataredi Sent: Monday, February 27, 2006 9:55 AM To: [email protected] Subject: [EDI-L] Inovis BizMapper (on Windows) and JDE - Julian Date Formatting We're trying to integrate julian date formatting by using javascript, in BizManager BizConnect v3.0.2 with BizMapper V3.7, so as to convert inbound and outbound maps (EDI to direct database integration, which is Enterprise 1 / Oracle) to and from Julian, which the database requires. Has anyone had any success with this? We keep getting an error and the documentation doesn't seem to help. Anyone with experience in Inovis BizMapper and julian date formatting, would love to get your input. Thanks, John 714 845 1111 . Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Access the list online at: http://groups.yahoo.com/group/EDI-L ________________________________ YAHOO! GROUPS LINKS * Visit your group "EDI-L <http://groups.yahoo.com/group/EDI-L> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . ________________________________ [Non-text portions of this message have been removed] . Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Access the list online at: http://groups.yahoo.com/group/EDI-L Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
