Max date

[_micom_]

Hello!

Sorry for my English.

There are SharePoint lists with devices and repair dates.

Devices:

|     ID     |     DeviceTitle     |

------------------------------
|     1       |         dev1          |
|     2       |         dev2          |
------------------------------

Repair
|      ID     |      DeviceID     |      DateOfRepair     |
----------------------------------------------------
|      1      |        1                | DateTimeValue1     |
|      2      |        1                | DateTimeValue1     |

I need to get a collection where the last repair date is selected for each device.

I take two steps:

ClearCollect( DeviceReps; GroupBy( Repair; "DeviceId"; "Attestations" ));;
ClearCollect( LastRepDate; AddColumns( DeviceReps ; "MaxDate"; Max( Repair; DateOfRepair ) ) )

I get a collection DeviceReps:

|     DeviceID     |      MaxDate       |
-------------------------------------
|       1               | 1528664400000 |
|       1               | 1550700000000 |

How to get DateTime from 1528664400000? Or another way?

Thanks!

[RandyHayes · Accepted solution]

@_micom_ 

Max is going to return a number.  Converting that back to a date is a challenge.

Here's another option to consider:

ClearCollect( LastRepDate; 
              AddColumns( DeviceReps ; 
                          "MaxDate"; 
                          First(Sort( Repair; DateOfRepair; Descending)).DateOfRepair
                        ) 
            )

This will sort the dates most recent being first and then take that first value of the DateOfRepair for your Column value.

I hope this is helpful for you.

[_micom_]

@RandyHayes 

Thank you very much. It works great for me.