DMAX Returning A Date One Day Early

[Eric_D_Miller]

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

[Sven-iX]

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]

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 · Accepted solution]

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})

[Sven-iX]

@Eric_D_Miller did you get it to work? 

[DeepaMa1]

Hi,

My DMAX is returning most recent date minus 1 day in my report calculation. Below is my code in the report. My fields are just date fields without any time. Any idea why it is showing one day less?

description=MAXDate
displayname=MAXDate
valueexpression=DMAX({project}.{DE:EPA Coc Received},{project}.{DE:FEDV Data Final})
valueformat=atDate

[jon_chen]

Hello @Eric_D_Miller 

I wanted to let you know that I'm marking a previous response as the correct solution. If this is incorrect or if you need more help from the community, please let me know, and I'll remove the marked solution.