JulianToDate UFL

[mwake]

I'm using CR10, reporting against a database that stores julian dates (ex. 731587), and I'm trying to convert them to Gregorian dates. I checked Crystal technical support on-line and found a JulianToDate UFL. I downloaded the .dll but it doesn't appear under the functions tab of the formula editor. I've never used a UFL before, so I was wondering if I needed to do anything else before I can use the function.

 

[dgillz]

Assumming you actually installed and/or registered the .dll, look under the "additional functions" section of the formula editor.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[synapsevampire]

Check this thread:

http://www.tek-tips.com/viewthread.cfm?qid=303387&page=1

I avoid using UFL's.

-k

 

[mwake]

The readme file that came with the UFL said I needed to copy the .dll file to my \WINDOWS\CRYSTAL directory, which I did. It does not appear under the additional functions section. DO I need to do anything else to make it appear??

I looked at the thread provided by Synapsevampire, but it won't work for me. I'm dealing with a number field that doesn't have the year (ex.731587=1/7/2004)

 

[synapsevampire]

There are different forms of a Julian date, I don't recognize yours.

I'm unfamiliar with that format, unless it's days since 1/2/0001, in which case use:

cdate(1,1,2) + {table.field}

-k

 

[Nuffsaid]

Hi,

Just out of curiosity, what transactional system are you reporting off of? Is the Julian date 693596 = Jan 1, 1900?

If so, don't bother with Crystals Julian UFL. As Synaps mentioned there are different forms and this one won't work for you.

Consider creating a period table that would store both Julian and Gregorian dates.

Nuffsaid.

 

[mwake]

I searched under Epicore here on Tek-Tips and found the solution:
dateadd("d",{appyhdr.date_applied} - 639906,#1/1/1753#)

That did the trick!!

 

[grangers]

Hi mwake

An alternative which we use for Epicor/Crystal reports is:

Date(01,01,01)+1+{appyhdr.date_applied}

 

[Nuffsaid]

Aha,

Epicor, thought so. FYI they have their own UFL for converting Julian dates.

Nuffsaid.