Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

How to display timestamp with AM and PM

Hello guys,   I have a calculated column named GetTime and its calculated the current timestamp. See the image below. I would like to display the value of this column in a chart and the output must...
Need Help
  • Daniil's avatar
    Daniil
    9 years ago

    I'm not exactly sure about "16:50 AM" (shouldn't it be 4:50 AM?), but there are at least two ways to accomplish your goal:

     

    1. Change formatting of the column
    2. Explicitly format the column as a text string:
      Gettime = FORMAT ( NOW(), "h:mm am/pm" )

    If you are using a card visual, the end result is almost the same. The second approach allows you to define capitalization (am/pm or AM/PM).

Daniil's avatar
Daniil
Icon for Kudo Kingpin rankKudo Kingpin
9 years ago

I'm not exactly sure about "16:50 AM" (shouldn't it be 4:50 AM?), but there are at least two ways to accomplish your goal:

 

  1. Change formatting of the column
  2. Explicitly format the column as a text string:
    Gettime = FORMAT ( NOW(), "h:mm am/pm" )

If you are using a card visual, the end result is almost the same. The second approach allows you to define capitalization (am/pm or AM/PM).

mateoc15's avatar
mateoc15
Icon for Advocate II rankAdvocate II
1 year ago

This is extremely helpful.  It's odd that DAX and the column version are different sets of formatting, for me it was specifically the "tt" for AM/PM in one and just plain "AM/PM" in the other.  In any event, it worked.  Thank you.