Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, Power Apps, Power Automate, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
Refer to below to learn about adding Julian Date format in Electronic reporting in D365 FinOps.
Open the designer, click on the row sequence that contains the date fields. Click on mapping
Click on ‘edit Formula’
On next screen, click on payments & then click on ‘add data source’ . ‘model.payments’ will appear in the white formula box. Or you can manually type this [emoticon:c4563cd7d5574777a71c318021cbbcc8]
Click save & then close the screen.
Time to define the date fields:
Click on date field1 , in this case I have named it as ‘YY’ . Note that type of the field is ‘DateTime’
Define format as ‘yyMMdd’ and field length as 2 (Minimum & maximum)
System will convert the date in ‘YYMMDD’ format and read just the 2 first characters. i.e 8th Oct,2019 will appear as ‘19’ in the file.
Click on mapping>Model>payments>RequestedExecutionDate and click Bind. The formula will appear on the left side of the screen
Click on ‘DDD’ field which is string type field. Click on mapping & then edit formula
On next screen, select the ‘DAYOFYEAR’ function and then click on add function. It will be added to formula box.
Click on Requested Execution date and then ‘Add data source’. The field will be added to formula box. Just manually type @. before the field name and close the bracket.
Save & test the formula
8th October is read as 281st day of the year
And this is how the value will look like in the file [emoticon:c4563cd7d5574777a71c318021cbbcc8], Julian date format.
Is this information related to a question that you have?
yes, i found the answer after bit of testing, so sharing this with the community
Thanks but I did not see a question here ;-)
What you can do next time is either post the answer to your original thread/question or alternatively post it on a blog that will by synced with the community.
Thanks for sharing and your community spirit :-)
Business Applications communities