I'm reformatting a date taken from a database, which is stored in the following format, where days/months/hours/minutes/seconds all have leading zeros:

DD/MM/YYYY HH:MM:SS AM/PM

I've already formatted it to how I want it, using this:

VB Code:
  1. dateFormat = "d/mm/yy h:mm"

  2.         Format(CDate(qry!Time), dateFormat)

This outputs the date as d/m/y h:m, with leading zeros only on months, years and minutes, and it works fine. The problem is that I can't get it to preserve the AM/PM, so is there any way to add that to it too using Format()? (and not resorting to using Left to get it from the original field value)