Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 .
@Paknanarn23 Could you please post some sample data?
This is the information I have.
But I only output one last value.
I use this code but it doesn't come out.
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 .