I have created julian date to normal date using microsoft sql server domain calculated fields in Jasper report server and it's working fine in Jasper report server. Please find below calculated field code.
"CASE WHEN (" + sqlArgs + " > 0 and " + sqlArgs + " is not null) then convert(Date,DATEADD(dd, (" + sqlArgs + " % 1000) - 1, DATEADD(yy, " + sqlArgs + " / 1000, 0)),120) else null end"
when I tried to retrieve in Jasper studio it's coming null value not date . How do I get the conversion calculated date value from jasper server to jasper studio?