Picking Last and Current Update

[Virikefe22]

Hello, I wish to pick just the date's time only (1) without the date showing in each case. And also show only name (2) of the newest record in each case. The column names in the SP list are Shift Coordinator (DataCardValue1) and Date (LastUpdate) respectively.

[NandiniBhagya20]

HI @Virikefe22 ,

You can use below formula to capture newest record - 

First(Sort(SPListName, Created, Descending)).'Shift Coordinator'

To display time part of a date and time field you can use split function - 

With({_dateF:Split(ThisItem.DateTimeColumn," ")},Last(FirstN(_dateF,2)).Result & Last(FirstN(_dateF,3)).Result)

[Virikefe22]

First(Sort(SPListName, Created, Descending)).'Shift Coordinator' (this line worked)

But the second didn't work: With({_dateF:Split(ThisItem.DateTimeColumn," ")},Last(FirstN(_dateF,2)).Result & Last(FirstN(_dateF,3)).Result)

It's showing nothing.

REMEMBER PLS: Only the time is what I want to show in the (1) from the SP List (1) previous record before the last in the SP list.

[NandiniBhagya20 · Accepted solution]

HI @Virikefe22 ,
Try using this - 

With({_dateF:Split(First(Sort(SPListName, Created, Descending)).Date," ")},Last(FirstN(_dateF,2)).Result & Last(FirstN(_dateF,3)).Result)

[Virikefe22]

Worked perfectly now. Thanks @NandiniBhagya20 

[Virikefe22]

Hello @NandiniBhagya20 

Little more issue. The last update according the to the SPList is 8.00AM and not 9.00AM

With your solution, it's showing the current time (2) and not the previous time (1) before the current (last) time.