Tag history Maximum don't return expected value

[jchen]

Hi there,

I have a tag with below history setting.

The tag value will be reset at 6:00 PM everyday, I need to know the maximun value around 6:00 PM.

Raw data looks good from table above, but if I change the table data setting to maximun, it gives a result 0, I believe in this time range I selected should get a result 39.

But if I change the date range before 6:00PM, I can get the right value.

The same result if I use script

system.tag.queryTagHistory(paths=tagPathList, startDate=startTime, endDate=endTime,  returnSize=1, aggregationMode="Maximum", returnFormat='Wide',noInterpolation=0,includeBoundingValues=1)

Any idea about the situation?

Thanks in advance.

[jchen]

One additional information.
If I select all the options under advanced, the raw data look like below: