I am trying to print a datestamp in an Excel Jaspersoft report with the time in 12-hour am/pm format. Under 'Dataset and Query', the database field (which is date format) has Class Type = java.sql.Date: In the table, under Text Properties, I am using the format 'MM/dd/yy hh:mm a', which is supposed to give me what I want: However, in the report, the timestamps are listed with military (24hr) time: What am I doing wrong? I should mention that I'm defining them as dates rather than strings so the user can sort them by date in the Excel file. Thanks in advance for any help - and please give specific instructions because I am not an expert at Jaspersoft Report! p.s. I am referring to this pattern guide: https://community.jaspersoft.com/wiki/date-and-time-patterns