Julian date in BMC Remedy ARS

[#1]

Hi, I'm trying to convert a Julian date (like this 2455825) to a regular date (20/09/2011), but the formulas I have found are not working for me. Can you help me why is different and what can I do?

I'm working with BMC Remedy ARS application on a SQL Server database.

Thanks!

[Gysbert_Wassenaar]

See Julian Date Conversion

[#3]

I've tried that, but it is giving me 04/04/4357 instead of 20/09/2011.

I used:

date(yearstart(makedate((((Fechainicio - fmod(Fechainicio,1000)) / 1000) + 1900))) + (fmod(Fechainicio,1000) - 1))

Am I doing something wrong or missing something?

Thanks!

[rbecher · Accepted solution]

Hi,

I would subtract the offset 2415019 (equivalent to 30.12.1899, which is day 0 in QlikView):

Date(JulianDateField - 2415019)

You probaly have to adjust the timezone since Julian Date is in UTC.

- Ralf