Rollup fields on Date-Only columns

(0) Share

Report

Posted on by Ben Walker

It doesn't seem possible to create rollup fields based on Date Only columns. In the Rollup Wizard, it only displays columns which are of type Date-Time, not Date Only. Can anyone confirm this?

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ben,

Through my test, I find that what shown in the rollup wizard based on rollup field behavior.

For example, I created two date and time fields, one is date only behavior, another is not.

when rollup field behaviour is date only, it just shows date only field in rollup wizard.

But if rollup field behaviour is not date only, it will not show date only field.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No
Ben Walker 22 on at

Like (0)

Report
Copy link

Link copied!

Hi Leah,

thanks for the reply. I did some more testing of my own last night and you are right - Date Only fields do sometimes show up in the Rollup editor, but not always.

If you look here, there are three custom Date Only fields on this entity:

but only one of them shows up in the wizard:

Either it's a bug, or there's some other aspect of the field that determines whether it can be included in the rollup or not. I'll carry on investigating today.

Thanks again,

Ben

Was this reply helpful? Yes No
Suggested answer

Ben Walker 22 on at

Like (0)

Report
Copy link

Link copied!

Hi again,

turns out that

a.) You can only base a Date-Only rollup on a Date-Only field but also

b.) The 'Behavior' setting needs to be the same for both fields.

I had a mismatch between the two fields and that's why it wasn't allowing me to create the rollup.

I'll mark this as closed.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ben,

As I said above, it just based on behavior of the field, no relationship of format.

Why three ‘date only’ field just one can be shown in the rollup wizard?

Because the other ‘date only’ field just format is ‘date only’, but behavior is ‘user local’, These two ‘date only’ are different concepts.

In the page, the data type shows the format of the date field, not behavior.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ben,

Please click Yes under "Did this answer your question?" to close this thread.

Thanks.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No