MS SQL Function to convert DateTime into JDE Julian
--CREATE FUNCTION dbo.JDEJulian (@inputdate datetime)
--RETURNS int
--
--BEGIN
-- declare @yr varchar(4)
-- declare @yeartest varchar(30)
-- declare @julianday int
-- declare @julian int
--
-- set @yr = (year(@inputdate))
-- set @yeartest = '01-01-'+@yr
-- set @julianday = (Datediff(day,@yeartest,@inputdate))+1
-- set @julian = '100000'+(1000*(right(@yr,2)))+@julianday
-- RETURN(@julian)
--END
MS SQL Function to convert JDE Julian into DateTime
--CREATE FUNCTION dbo.JDEDate (@inputdate varchar(6))
--RETURNS datetime
--
--BEGIN
-- declare @yr varchar(4)
-- declare @yeartest datetime
-- declare @julianday int
-- declare @output datetime
--
-- set @yr = (substring((@inputdate),2,2))
-- set @yeartest = '01-01-'+@yr
-- set @julianday = (right(@inputdate,3))
-- set @output = CONVERT ( VARCHAR (10), DATEADD( day , @julianday -1, @yeartest ) , 120 )
--
-- RETURN(@output)
--END