Perspective Table Excluding 'AM and 'PM' When Using dateFormat

Ignition
, ,
1

Hello!

I am having a hard time trying to get the dateFormat to return either 'AM or 'PM' when the render is set to date

I have the dateFormat set to M/DD/YY HH:mm if I add the 'tt' as you would within a SQL query, it doesn't format as intended:

image
image921×594 33.4 KB

I have also tried it with the pre-selected dateFormat of MM/DD/YYYY HH:mm:ss and added tt but still didn't produce the expected results.

Is this possible within the table component? If not, is there a possible workaround?

Thank you!

2

Use M/DD/YY HH:mm A. Perspective uses moment.js rules for formatting dates

2 Likes
3

Ah that was it! I knew it was something I was missing. Thank you so much for the quick response!

1 Like