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


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:

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!

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


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

1 Like