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.
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 (http://aa.usno.navy.mil/data/docs/JulianDate.php)
---
Andrew
http://metatheory.wordpress.com (http://metatheory.wordpress.com)