Finance | Project Operations, Human Resources, ...

Convert time period to Y:M:D format x++

(0) Share

Report

Posted on by Dynamics365

Hi all,

I have a requirement in which I need to display a time period calculated to a format like this Y:10 M:5 D:20.

For example if I calculate an employee's service time and it is 10 years then I want to show this period like this (Y:10 M:2 D:18)

Is there any function in x++ to do this ?

Please, help me if any one knows something about it

Regards,

I have the same question (1)

All responses (12)

Answers (0)

nmaenpaa 101,166 Moderator on at

Like (0)

Report
Copy link

Link copied!

In what format do you have the employee's service time right now?

Was this reply helpful? Yes No
Martin Dráb 239,040 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Which versionn are you talking about? You've attached tags for both D365 and AX 2012.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,166 Moderator on at

Like (1)

Report
Copy link

Link copied!

Anyway, let's assume you used DateTimeUtil::getDifference to get difference of two date times.

Then you have the difference in seconds.

It's trivial to transform the difference to days: seconds DIV 86400 (86400 is the nr of seconds in a day).

But the next steps are not so easy, and actually not even possible if you only have the difference.

The exact number of years, months and days depends on leap years and the length of different months.

In order to know them, you need to keep the employment start date and end date in your calculations all the time. There might be some libraries to get the result.

Here's some discussion on how to do it in C#.

Was this reply helpful? Yes No
Dynamics365 70 on at

Like (0)

Report
Copy link

Link copied!

sorry for not mentioning

I'm using D365

Was this reply helpful? Yes No
Dynamics365 70 on at

Like (0)

Report
Copy link

Link copied!

UTCDateTime

Was this reply helpful? Yes No
Martin Dráb 239,040 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

UTCDateTime contains a date, such as 7/12/2020, not a time span such as 10 years.

Was this reply helpful? Yes No
Dynamics365 70 on at

Like (0)

Report
Copy link

Link copied!

Martin, is there a way to achieve what I explained earlier?

Was this reply helpful? Yes No
Martin Dráb 239,040 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Sure, it is. But we can't tell you details about what you should do until you explain what you use as the input.

Was this reply helpful? Yes No
Dynamics365 70 on at

Like (0)

Report
Copy link

Link copied!

What I'm doing is, I'm getting the WorkerStartDate value in a temp table with field HcmEmploymentValidFrom.

Then in the report design, I'm using expression DateDiff("YYYY",Fields!HcmEmploymentValidFrom.Value,Now()).

and It return the date difference like 10 , 5 or 6 years.

Was this reply helpful? Yes No
nmaenpaa 101,166 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi KZOo,

thanks for the information.

And do you want to show on your report just the nr of years? Or years, months and days as you wrote before?

As mentioned, it can be a bit tricky because of leap years, different lengths of months and so on. But if you need to show only full years it's simpler.

Was this reply helpful? Yes No