rubinjm

calculating min/max date from timestamp

Discussion created by rubinjm on Feb 9, 2017
Latest reply on Feb 9, 2017 by user19752

I have a timestamp field and would like to calculate the first and last date in my group of records so I can display those on a chart.

 

I have tried creating calculations using

Min ( timestamp ) and Max ( timestamp )

with global storage and calc result as a date

 

but maxDate is showing as 2/9/17 and minDate is showing as 2/9/17.

 

Min should be 2/8 and max should be 2/9.

Outcomes