Convert Date To Julian In D365 Electronic Reporting Formula Editor

Often when talking to third-party systems/softwares, there is a requirement to transmit a Julian date in the file. A similar requirement here I had to pass today’s date formatted in Julian in the EFT file which was being generated using Electronic Reporting in Dynamics 365 Finance. To accomplish this, I used below formula in formula editor of electronic reporting. I am using today’s date here however as per your need, you can change that to a date from a data source/field as needed. 

1000*(INTVALUE(DATEFORMAT(TODAY(),”yyyy”))-2000)+DAYOFYEAR(TODAY())

So today’s date, 5/12/2020 gets converted to Juian date 20133

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.