web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Split dates between Va...

Microsoft Dynamics AX (Archived)

Split dates between ValidFrom and ValidTo for reporting

(0) Share

Report

Report

Posted on by Parag Chapre

12,254 Most Valuable Professional

Hello,

I want to split records in Table between ValidFrom and ValidTo dates and use in reporting.

For eg. Employment is from 1st Oct 2018 to 31st Oct 2018 and I want create 31 records in Table. We want to split records to do calculation per day for an employee.

Company

Employment end date

Employment start date

Personnel number

Employment ID

TEST

31 Oct 2018

1 Oct 2018

000001

000055

Is there any functions where I can do split records in table for reporting purpose?

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

Hi Parag Chapre!

You can create tmpTable and insert aggregated values in this table and then use it in your report.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 39

#2

#3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans