Using Format with Date

[Middlemarch]

Just wondering why Debug.Print Format(Now, "dd/mm/yyyy")
prints 06, 02, 2023 instead of 06/02/2023 ?

[June7]

No idea. I get 05/02/2023.

[Middlemarch]

Yes, that's what i thought I used to get... but now it's different . Using Office 2019 and find Excel also shows space and comma.
If I try another computer with Office 2016 it follows the format instruction as expected.
Is it a bug in Office 2019? Could someone else with this version try please?
LOL I always thought my Access was bugged as it so often does when I don't want or expect !
I found something on Google about changing separators, but it said to use File-Options-Advanced. My Access has no "advanced". Is this normal?

[June7]

In Access there is File>Options>ClientSettings>Advanced but nothing there about changing separators.

Excel has File>Options>Advanced but nothing there about changing date separators.

[Middlemarch]

Thanks @June. Same here. Seems separators work as expected here except the for slash characters.

? Format(DateAdd("ww", 1, Now), "dd mmm yyyy")
13 Feb 2023
? Format(DateAdd("ww", 1, Now), "dd.mmm.yyyy")
13.Feb.2023
? Format(DateAdd("ww", 1, Now), "dd-mmm-yyyy")
13-Feb-2023
? Format(DateAdd("ww", 1, Now), "dd/mmm/yyyy")
13, Feb, 2023


? Format(DateAdd("ww", 1, Now), "dd, mmm, yyyy")
13, Feb, 2023
? Format(DateAdd("ww", 1, Now), "dd,mmm,yyyy")
13,Feb,2023
? Format(DateAdd("ww", 1, Now), "dd\mmm\yyyy")
13m02y2344
? Format(DateAdd("ww", 1, Now), "dd#mmm#yyyy")
13#Feb#2023


? Format(DateAdd("ww", 1, Now), "dd//mmm//yyyy")
13, , Feb, , 2023


? Format(DateAdd("ww", 1, Now), "dd&&mmm&&yyyy")
13&&Feb&&2023

[June7]

Try: Format(Now, "dd\/mm\/yyyy")

[Middlemarch]

Nice solution. That did work

? Format(Now, "dd\/mm\/yyyy")
06/02/2023
But I'm sure it used to work how it does for you. You wonder why/how and what else might have changed.

[June7]

Never seen this.

You are not in U.S.? Can only guess it has something to do with regional settings.