I have multiple start times.

[Paknanarn23]

I want to use the last time of the start time in I tried to code Max(Remark (Start Time)) but it didn't work.

[sidhiq91]

@Paknanarn23  Could you please  post some sample data?

[Paknanarn23]

This is the information I have.

But I only output one last value.

I use this code but it doesn't come out.

[MayilVahanan · Accepted solution]

Hi

You have multiple dates at the same rows and it's in text format.

You can split the dates by using subfield() function and then convert the dates from text format to date format by using timestamp(timestamp#()) like below

subfield([Remark (Start Time)], ';') as datefield

timestamp(timestamp#(datefield, 'MM/DD/YYYY HH:mm:ss'), 'MM/DD/YYYY HH:mm:ss')

Then you can use Max(datecolumn) will work .