Julian Date NAV

pruebasEx

Is there any function in Navision to obtain/convert a date like 30-10-2015(DDMMYYYY) to a Julian Date ?.

Sunset

There is no function as such, but you can subtract any two dates and then just add the days needed.
For instance (TODAY - 01010001D) + 1721423

ama

JulianDate := TODAY-CALCDATE('<-CY>',TODAY)+1;

Where JulianDate is an integer.

Will work for TODAY. Just substitute TODAY with whatever your date is you want to calculate the julian date for. Will give you a number between 1 and 365

Sunset

There is no function as such, but you can subtract any two dates and then just add the days needed.
For instance (TODAY - 01010001D) + 1721423

ama

JulianDate := TODAY-CALCDATE('<-CY>',TODAY)+1;

Where JulianDate is an integer.

Will work for TODAY. Just substitute TODAY with whatever your date is you want to calculate the julian date for. Will give you a number between 1 and 365