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:
dateFormat = "d/mm/yy h:mm" 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)