Results 1 to 3 of 3

Thread: julian date conversion

  1. #1

    julian date conversion

    Hi,
    I wan to use the G/L date in a parameter in crystal reports. But first a think I need to convert the G/L date from the julian date.
    Anyone any ideas how to write this in SQL language via the command promt ??

    stefan


  2. #2
    Senior Member DSauve's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA
    Posts
    1,248

    Re: julian date conversion

    Stefan,

    Congratulations on your first post on JDEList. Please be sure to follow the guidelines for posting, especially including your system configuration in your posts. If you search JDEList, you'll find that this subject has been discussed many times. Formulas have been given for doing this date conversion.

    One thing that people have done and posted is to create database views, and then report off those views. Here's where your system configuration comes in. Depending on your database, there will be somewhat different commands to create the function to convert the julian date to a regular date field.

    I'd suggest you at least do a search of JDEList, and then post back if you have any questions, including your configuration info.

    Cheers!
    Don Sauve
    Wagstaff, Inc.
    E1 9.2, Win2016, SQL Server 2016, TR 9.2.2.6, WebLogic 12.2.1, BI Publisher

  3. #3
    Look this example in crystal reports :

    numbervar JulianDate:={F4211.SDCNDJ};

    stringvar DateString;
    dateTimevar NewDate;


    DateString := ToText(JulianDate,3);
    NewDate:=Date (2000+ToNumber(Mid(DateString,2,2)),1 ,1 );
    NewDate:=DateAdd("d", ToNumber(Mid(DateString,5, Length(DateString)-4))-1, NewDate);

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.