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?