Results 1 to 5 of 5
-
2018-07-06, 18:49 #1
- Join Date
- Jun 2010
- Location
- Indy
- Posts
- 1,550
- Thanks
- 347
- Thanked 281 Times in 234 Posts
Access 365 change Date Format of table contents
I want our dates in mm/dd/yyyy format, ie 2 digits for month & day incl leading zero, & 4 year digits. I've changed the input mask from…
99/99/0000
to…
00/00/0000
…which should take care of this going forward.
Is there an easy/auto way to change the existing table contents?
The only issue is the leading zeros for mm & dd.
PS fyi re Input Mask:
"9" means user MAY enter a digit;
"0" means user MUST enter a digitLast edited by Lugh; 2018-07-08 at 17:59. Reason: PS
Lugh.
~
Dell Alienware Aurora R6; Win10 Home x64 1803; Office 365 x32
i7-7700; GeForce GTX 1060; 16GB DDR4 2400; 2 x 256G SSD, 4TB HD
-
2018-07-07, 01:17 #2
- Join Date
- Dec 2009
- Location
- Earth
- Posts
- 9,179
- Thanks
- 69
- Thanked 1,165 Times in 1,083 Posts
Wouldn't you be better off saving the data as a date and then formatting it as required for display?
That input mask would allow dd/mm/yyyy input, e.g. 07/06/2018. It may be worth displaying it as dd MMM yyyy so users can be sure they got it right.
cheers, Paul
-
2018-07-08, 18:07 #3
- Join Date
- Jun 2010
- Location
- Indy
- Posts
- 1,550
- Thanks
- 347
- Thanked 281 Times in 234 Posts
Thanks Paul. Yes, you are right, this is what we do everywhere else.
Our recent problem is with a large outside company we upload info to. They provide a spreadsheet template, and the latest version of it somehow prevented reformatting 7/6/2018 to 07/06/2018—problem being dates without leading zeros caused our upload to fail.
They fixed the problem yesterday, but have a history of messing things up with untested changes to various systems, so I try to foolproof our end as much as possible.
However…
I've probably got this wrong. Access probably can't store a format with a date, can it? Ie format is always a display choice.Lugh.
~
Dell Alienware Aurora R6; Win10 Home x64 1803; Office 365 x32
i7-7700; GeForce GTX 1060; 16GB DDR4 2400; 2 x 256G SSD, 4TB HD
-
2018-07-08, 20:09 #4
- Join Date
- Mar 2004
- Location
- Manning, South Carolina
- Posts
- 10,161
- Thanks
- 450
- Thanked 1,655 Times in 1,488 Posts
Lugh,
You can set the format in the Table Definition.
AccessTableDateFmt.JPG
Result:
AccessTableFmt.JPG
HTHMay the Forces of good computing be with you!
RG (still RetiredGeek on AskWoody.com)
PowerShell & VBA Rule!
My Systems: Desktop Specs
Laptop Specs
-
The Following User Says Thank You to RetiredGeek For This Useful Post:
Lugh (2018-07-10)
-
2018-07-10, 06:26 #5
- Join Date
- Jun 2010
- Location
- Indy
- Posts
- 1,550
- Thanks
- 347
- Thanked 281 Times in 234 Posts
Lugh.
~
Dell Alienware Aurora R6; Win10 Home x64 1803; Office 365 x32
i7-7700; GeForce GTX 1060; 16GB DDR4 2400; 2 x 256G SSD, 4TB HD