Skip to Content
Former Member
Jan 24, 2011 at 06:18 PM

Julian Date Conversion (Dublin Julian)



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,