Julian Date Conversion (Dublin Julian)

[Former Member]

Hi,

I'm working with BO Designer and am connecting to an AS400 database that uses Dublin Julian for the date field. I'm trying to get the Dublin Julian format to the YYYY-MM-DD format. Currently, the Dublin Julian is formatted as a 5 digit number field. For example, 2011-01-31 would be represented as 40574. I believe the epoch, or start count day for the Dublin Julian day fell on Sunday, December 31, 1899. Can anyone help me with this calculation within Designer?

Thank you,

Tyler

[Former Member · Accepted solution]

You should be able to convert the 5 digit integer to a date by using the date function within the Crystal Reports Designer tool. The formula could look like this:

date(.)