Converting date time format to mm/dd/yyy format

[bknight]

I've got a day/time field that I would like to convert to mm/dd/yyyy format in a grouping query. Tradedate: Int(Day([NinjaTrader2024_PA].[Time])) and I received a group of days. So I'd like the specific format mm/dd/yyyy. Is there a format instead of concat 3 date/times with 2 "/" between them?

[bknight]

Never mind I just removed the Day and got a m/dd/yyyy format which should be fine. Tradedate: Int(([NinjaTrader2024_PA].[Time])) formatting the field to short date.

[Gasman]

I used to use this format constant for my dates.

Code: Select all

Public Const strcJetDate = "\#yyyy-mm-dd\#"  'Needed for dates in queries as Access expects USA but will accept ISO format.

[bknight]

I used to use this format constant for my dates.

Code: Select all

Public Const strcJetDate = "\#yyyy-mm-dd\#"  'Needed for dates in queries as Access expects USA but will accept ISO format.

Will that expression work in a query?

[Gasman]

I don't know, let me check.

No.

I actually only ever used it for VBA.
Then again a simple "mm/dd/yyyy" works in queries, so the complexity is never needed in queries, just in VBA?