DMAX Returning A Date One Day Early | Community
Skip to main content
Eric_D_Miller
Eric_D_Miller
Level 5
March 13, 2025
Solved

DMAX Returning A Date One Day Early

  • March 13, 2025
  • 1 reply
  • 687 views

Hello,

 

I have a calculated field that displays the latest date among a selection of fields. One such field is a multi-checkbox, each with their own start date field. I am attempting to pull the latest date from these selections but for some reason my calculation spits out a date that is one day earlier than the latest date.

 

For example, if the latest date in a selection of multiple fields is 3/30, my calculation will say 3/29.

 

Here is the specific part of my code that relates to the Multi-checkbox field:

 

 

 

DMAX( {DE:Start Date - xx}, {DE:Start Date - xx}, {DE:Start Date - xx}, {DE:Start Date - xx}, {DE:Start Date - xx}, {DE:Start Date - xx}, {DE:Start Date - xx}, {DE:Start Date - xx}, {DE:Start Date - xx}, {DE:Start Date - xx} ), "" ),

 

 

Here you can see that the dates are indeed 3/30 but the calculation (last column) is 3/29.

 

 

Anything look off? Thank you!

 

-Eric

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Sven-iX

Got it. 

So I recreated this - and it seems to work : I use the same DMAX expression in the calculated field and in the dynamic field in the report. All date fields are date (without time). Except for the silly date format (calculated field, I am in EMEA).

DMAX({DE:date1},{DE:date2},{DE:date3},{DE:date4})

 

 

1 reply

Sven-iX
Community Advisor
Sven-iXCommunity Advisor
Community Advisor
March 13, 2025

Are ALL the date fields dropdowns? I'm not tracking on " One such field is a multi-checkbox, each with their own start date field"

 

My hunch is that one or more of the fields is treated like a string instead of a date value. 

Eric_D_Miller
Eric_D_MillerAuthor
Level 5
March 14, 2025

Hi Sven,

Confirming that all of the fields I am keying off are Date fields.

 

When I say "One such field is a multi-checkbox, each with their own start date field" I mean that I have a checkbox field that when each box is selected, a different date field populates. I would like the latest date of those selections to populate in my calculated field but it appear to take one day away instead.

Sven-iX
Community Advisor
Sven-iXCommunity AdvisorAccepted solution
Community Advisor
March 14, 2025

Got it. 

So I recreated this - and it seems to work : I use the same DMAX expression in the calculated field and in the dynamic field in the report. All date fields are date (without time). Except for the silly date format (calculated field, I am in EMEA).

DMAX({DE:date1},{DE:date2},{DE:date3},{DE:date4})

 

 

Terms & ConditionsAccessibility statement

Loading footer...