Re: Cloud Date Entry

<Anthony.Youngman@xxxxxxxxxxxxxxxxxxxxx> wrote in message news:a8562a32-a0e2-4c5e-8ee6-a5c5d41ffb1d@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Aug 20, 4:33 am, Ross Ferris <ro...@xxxxxxxxxxxxxx> wrote:
On Aug 20, 9:32 am, "Mark Brown" <Mark_Br...@xxxxxxxxxxxxx> wrote:
: There's no way to tell if they are entering the date correctly vis-a-
vie
: international format or not.
:
: 6/13/2008
:
: Perfectly valid and 50-50 chance of being wrong, depending on which
side of
: the waters you are.
:

C'mon Mark, this should be 100% every time --> a seperated field
with a "13" not in the last column, which is OBVIOUSLY a day ....
even 61308 should be able to be resolved correctly every time .... now
"6138", THAT is a data that could be 50/50 :-)

You obviously don't know the Pick date functions very well :-)

61308 *IS* ambiguous, and if you iconv it it will come out as "4 Nov
1961".


Thanks, but he was right. I mis-typed. I meant to say 6/12/2008 was ambiguous because there's just no way of knowing if the intention was June 12th or December 6th.

One of the advantages of programming in Windows, esp VB, is that you can rely on the local "settings" to correctly format the date.

On the other hand, relying on individual work stations to keep the correct date and time might be a bit dicey. We generally use a subroutine call to get the date and time as the "server" sees it. At least the users generally enter the date in the same format all the time. I have a client who insists on entering his dates as mm-dd-yy and can't understand why date ranges (mm/dd/yy - mm/dd/yy) won't work (duh... mm-dd-yy-mm-dd-yy??)

Mark

.

Relevant Pages

  • Re: Date Format for Userform TextBox
    ... my company have been entering dates in this format for the past decade so it ... I have a userform that uses a textbox fot entering a date: ... However when I type 2/3 in the textbox in the userform it returs 3/Feb/2009 ... the textbox interprets the 2 as the month and the 3 as the date. ...
    (microsoft.public.excel.newusers)
  • Re: Format a textbox
    ... the format is not preserved. ... In addition to this I would set the MaxLength of the TextBox to 13 to limit the number of digits after the hypen to 4. ... Private Sub TextBox1_KeyUp ... For instance when a person is entering the ...
    (microsoft.public.excel.programming)
  • Re: How do I sort dates in Excel
    ... I already gave you my suggestion, keep entering as text as you are ... You cannot have dates before 1900 in Excel by itself. ... Don't change the format from what you have and do make sure ... Also if you are talking about genealogy a date of 28-Apr 1893 is not going ...
    (microsoft.public.excel.misc)
  • Re: Date fomula not working
    ... I am entering last year's bills as a record. ... "Rick Rothstein" wrote: ... Rick (MVP - Excel) ... If you use the formula =A2 and format as General, ...
    (microsoft.public.excel.worksheet.functions)