I'm looking for a function in Access 2007 that will allow me to run a query that for a date field will only return the dd/mm/yyyy, and strip the time that is at the end of the line.
I've done some searches, but all I've been able to come up with is Trunc(), which apparently is only an Oracle function?
Any help would be MUCH appreciated!
I've done some searches, but all I've been able to come up with is Trunc(), which apparently is only an Oracle function?
Any help would be MUCH appreciated!