Convert timestamp to date or time in a message thread

AppSheet AppSheet Q&A
,
1

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 !

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

Thanks !

I used the same method to also format the date :

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

To turn this :

4/4/2023

into :

04/04/2023

1 Like