Just wondering why Debug.Print Format(Now, "dd/mm/yyyy")
prints 06, 02, 2023 instead of 06/02/2023 ?
Just wondering why Debug.Print Format(Now, "dd/mm/yyyy")
prints 06, 02, 2023 instead of 06/02/2023 ?
No idea. I get 05/02/2023.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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?
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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
Try: Format(Now, "dd\/mm\/yyyy")
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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.
Never seen this.
You are not in U.S.? Can only guess it has something to do with regional settings.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.