From: Dave Jones (DAVERJ) [#12]
26 Jan 2007
To: Harvey only (HARVEY-ONLY) [#11] 26 Jan 2007
A feature like that would have to not only insert the date automatically, but allow a full custom date format in order to meet the non-standard format he needs.
From: Carl (CSEWELL) [#13]
26 Jan 2007
To: Dave Jones (DAVERJ) [#12] 26 Jan 2007
That's a fairly standard format. Most commercial software allows you to specify date fields in an MMDDYYYY format. VBA supports that also.
From: Dave Jones (DAVERJ) [#14]
26 Jan 2007
To: Carl (CSEWELL) [#13] 26 Jan 2007
Well the VBA Format() funtion can certainly format date strings to user specs, but I was thinking more about the built in current date string that a lot of programs provide. Most of those that I've seen only offer standard US and European date formats.
From: Carl (CSEWELL) [#15]
26 Jan 2007
To: Dave Jones (DAVERJ) [#14] 27 Jan 2007
If you want to get down to the system level, Windows operating systems allow you to specify the date format (as in mmddyyyy, or whatever) that application software will use for the default, provided they are using operating system calls to get the date, of course. It surprised me that that functionality existed in Windows.
From: logojohn [#16]
27 Jan 2007
To: laserman (MIKEMAC) [#10] 29 Jan 2007
quote:
12607
Couldn't that be 1-26-07
or 12-6-07
Might help to field fill with zeros
012607
120607
Show messages: All
1-11
12-16