Format of Date from Query 1

[ptrifile]

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

 

[Andrzejek]

[TT]Debug.Print Format(Date(), "MM/DD/YYYY")[/TT]
in Excel VBA gave me
[tt]09/01/2020[/tt]


---- Andy

There is a great need for a sarcasm font.

 

[ptrifile]

Thanks Andy, I am using this in a MS Access query but this helped me get the desired results. Thanks again!