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 (0)

All responses (12)

Answers (0)

nmaenpaa 101,160 Moderator on at

Like (0)

Report

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

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

Like (0)

Report

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,160 Moderator on at

Like (1)

Report

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

sorry for not mentioning

I'm using D365

Was this reply helpful? Yes No
Dynamics365 70 on at

Like (0)

Report

UTCDateTime

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

Like (0)

Report

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

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

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

Like (0)

Report

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

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,160 Moderator on at

Like (0)

Report

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

Join the conversation

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates