<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Ken,<br>
<br>
See my <font color="#3366ff">comments</font> below.<br>
<br>
Richard<br>
<br>
On 10/7/2015 9:28 AM, Kenneth Brody wrote:<br>
</div>
<blockquote cite="mid:56152BF5.50800@spamcop.net" type="cite">On
10/7/2015 9:01 AM, Richard D. Williams via Filepro-list wrote:
<br>
[...]
<br>
<blockquote type="cite">Have to fields for the data, one is a
regular date edit (10, mdyy/)and the
<br>
other simply require nn/nn/nnnn. (n could be a number or n could
be a ?)
<br>
Put a dummy field on the screen with the nn/nn/nnnn edit
<br>
When the cursor leaves this field you must first look for any ?,
this would
<br>
tell you NOT to fill in the real date field and put this data
into the other
<br>
real field.
<br>
</blockquote>
<br>
Why look for "?"? Why not just store it into your mm/dd/yyyy
field? If it's a valid date, you'll get a valid date field. If
not, you'll get a blank date field.
<br>
</blockquote>
<font color="#000099"><font color="#3366ff">I think he wants to
attempt to get all dates in the generally correct chronological
order.<br>
So if a date is entered as 10/??/2010, at least this will be in
chronological order as 10/00/2010.<br>
Or 10/07/???? will still be at the beginning. He can also see
which part of the date is missing.</font><br>
</font><br>
<font color="#3366ff">If the date is blank they will all be at the
beginning.</font><br>
<blockquote cite="mid:56152BF5.50800@spamcop.net" type="cite">
<br>
<blockquote type="cite">If there are no ? in the field, test it by
using another dummy var while a
<br>
real date edit and attempt some date math, i.e.
ha(8,mdy/)=hb+"0", (hb is
<br>
the dummy var on the screen)
<br>
</blockquote>
<br>
Adding zero to a non-date field will not get you a date, even if
that field "looks like" a date. Adding zero to a non-date
"10/07/2015" would result in "10".
<br>
<br>
<blockquote type="cite">If you get 01/01/83 or no date at all you
know there is an issue.
<br>
</blockquote>
<br>
When would you get "01/01/83"?
<br>
</blockquote>
<font color="#3366ff">If a text field like 13/43/2015 is place into
a date field of hc(10,mdyy/).<br>
If you try to any math on that field, like hb(8,mdy/)=hc+"0", hb
will be "01/01/83".</font><br>
<blockquote cite="mid:56152BF5.50800@spamcop.net" type="cite">
<br>
[...]
<br>
<blockquote type="cite">
<blockquote type="cite">I need a special edit that allows the
entry of bad dates AND allows for date
<br>
math. For example we have a lot of invoices that portions of
the date is
<br>
unknown like having a missing day part or a missing month
part, or a missing
<br>
year part.
<br>
<br>
<br>
??/02/2000
<br>
<br>
12/??/2000
<br>
<br>
12/15/????
<br>
</blockquote>
</blockquote>
[...]
<br>
<br>
</blockquote>
<br>
</body>
</html>