• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

julian date conversion

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




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.



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);