https://community.incorta.com/t5/dashboards-analytics-discussions/the-undiscovered-country/m-p/3853#M330 <P>I think I found a bug in the toChar() function but want to make sure here first.</P><P>When using the format "HH:mm", toChar() does not emit 24 hour time format. Instead it emits "hh:mm" format. Also, if I try to give it "hh:mm a" as a format string, it complains that it is not a valid format.</P><P>formatDate() does work as expected with the "hh:mm a" and "HH:mm" formats.&nbsp;</P><P>Anyone else notice this? I suspect toChar() is not oft used.</P> Thu, 02 Mar 2023 22:25:38 GMT marcpaige 2023-03-02T22:25:38Z https://community.incorta.com/t5/dashboards-analytics-discussions/the-undiscovered-country/m-p/3853#M330 <P>I think I found a bug in the toChar() function but want to make sure here first.</P><P>When using the format "HH:mm", toChar() does not emit 24 hour time format. Instead it emits "hh:mm" format. Also, if I try to give it "hh:mm a" as a format string, it complains that it is not a valid format.</P><P>formatDate() does work as expected with the "hh:mm a" and "HH:mm" formats.&nbsp;</P><P>Anyone else notice this? I suspect toChar() is not oft used.</P> Thu, 02 Mar 2023 22:25:38 GMT https://community.incorta.com/t5/dashboards-analytics-discussions/the-undiscovered-country/m-p/3853#M330 marcpaige 2023-03-02T22:25:38Z