Solved: Convert timestamp to date or time in a message thr... - Page 2

Bulubulu · 04-05-2023 06:23 AM

I'm trying to create a comment thread. I would like the message list to show the time instead of the date if the timstamp matches today's date.

I'm currently using this formula in a "DisplayDate" column :

IF(
 DATE([DateCreation])=TODAY(),
 TEXT(TIME([DateCreation])),
 TEXT(DATE([DateCreation]))
)

It seems to works, but how can I convert this result :

1:51:01 PM

Into :

13:51

?

Thanks for your help !

diogolupcosta

IF(
 DATE([DateCreation])=TODAY(),
 TEXT(TIME([DateCreation]), "HH:MM"),
 TEXT(DATE([DateCreation]))
)

Convert timestamp to date or time in a message thread