I have a simple query where I am adding today's date in a field and then adding 12:59:59 to the end of the date. My question is, the query is resulting in the following:
8/3/2020 12:59:59
and would like it to be formatted as follows:
08/03/2020 12:59:59
The query I am using is
IDate: Date() & " " & "12:59:59"
Can someone help me get the desired results? I have tried numerous "format" options but must not be getting the context correct.
Thank you,
Paul
8/3/2020 12:59:59
and would like it to be formatted as follows:
08/03/2020 12:59:59
The query I am using is
IDate: Date() & " " & "12:59:59"
Can someone help me get the desired results? I have tried numerous "format" options but must not be getting the context correct.
Thank you,
Paul