I need to timestamp or set particular dates which I will be
writing to a datetime field in a mySQL database.
The format for that looks like this: 2009-01-23 01:01:01
I am able to write to the field by formatting like this:
dateformat(Now(), "yyyy-mm-dd hh:mm:ss")
The problem is the "minutes" take on the "month" value
(because I'm using the letter "m" in both places). Is there another
letter other than "m" that I should be using for minutes? I have a
reference book that says "n" but that didn't work. I'll attach the
basic code below.