Skip to main content

Show 'time' only in 'date' field such as '17:56' instead of '2020/12/15 17:56'

  • December 15, 2020
  • 2 replies
  • 79 views
J
Forum|alt.badge.img+3

Is it possible?

I need the timestamp feature that I can record the current time just with one or two click(s)
but still can be modified manullay.

I use ‘date’ field for this purpose but it displays date that I dont’t need.
Duration field shows only time but it does not support one-click current time insertion.

The only work-around I found is
Column A: date field: 2020/12/15 17:56
Column B: formula filed: DATETIME_FORMAT(‘Column A’, ‘hh:mm’)

There are two problems.

  1. I have to use two columns to show only one field
  2. Column B has a timezone issue.
    (I live in UTC+9 area. The column A has a local time but column B shows UTC time.
    So A is 2020/12/15 17:56, but B is 08:56

Thanks.

    2 replies

    ScottWorld
    Forum|alt.badge.img+35
    • ScottWorld
    • Genius
    • December 15, 2020

    You are correct about all of your options.

    You can use the SET_TIMEZONE function in your formula field, like this:

    DATETIME_FORMAT(
SET_TIMEZONE({Column A},'America/Los_Angeles'),
'hh:mm')

    For an even deeper dive into time zones, you can check out my sample base & training video here:

    J
    Forum|alt.badge.img+3
    • Jeongyong_Kim
    • Author
    • New Participant
    • December 17, 2020

    You are correct about all of your options.

    You can use the SET_TIMEZONE function in your formula field, like this:

    DATETIME_FORMAT(
SET_TIMEZONE({Column A},'America/Los_Angeles'),
'hh:mm')

    For an even deeper dive into time zones, you can check out my sample base & training video here:


    I appreciate your comment. It needs to create one more field. One for the timestamp itself which shows date and time, and another formula field to show time only…

    Terms & ConditionsAccessibility statement