Translate Julian date to local date

[timle]

hello,
would someone show me how to translate Julian date to local date

231 = 0819

thank you

[JRL]

I don't have an answer but it would be helpful to know how you define Julian date. I believe that officially it is a number where 0 represents noon on January 1, 4713 BC. In looking this up it seems it has been redefined in several other ways Explained HERE. How are you defining Julian date?

[timle]

my mistake when giving you the example. I have corrected it, it should be like below

231 corresponds to 231st day of the year which is August 19th

[JRL]

For that you could use vbscript datediff.

Code: Select all

Year>yyyy
sub>yyyy,1
VBEval>datediff("d","12/31/%yyyy%",(now)),res
MDL>res

[timle]

This change from local date to Julian date. how can you convert from Julian to local

thank you

[JRL]

Oops. Try this instead.

Code: Select all

Let>vDays=231

Year>yyyy
VBEval>datediff("d","12/31/1899","01/01/%yyyy%"),res
Add>res,%vDays%
VBEval>FormatDateTime(%res%,0),vResDate

MDL>vResDate

[timle]

Awsome thank you