Converting Julian Dates

[damienm]

Does anyone know if its possible to convert Julian Dates in FM? or Report Studio even!

I do have a date table but rather than having an extra table I would prefer to have a cal field to do this.

Any help would be much appreciated.

[arickard]

I don't think I've seen a function that can convert from gregorian to julian dates.

Instead of adding a new table can't you simply add a new column to your date table to represent the julian date. As I understand it every gregorian date should have a coresponding julian date.  When you load data into your date table you could set both the gregorian and julian date.


Julian Date Converter:
http://aa.usno.navy.mil/data/docs/JulianDate.php

---
Andrew
http://metatheory.wordpress.com