<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#330099" bgcolor="#FFFFFF">
<tt>Scooter,<br>
I would add to this date edit issue, that I have had issues in the
past when dates were stored with a dash instead of a /.<br>
I can not recall exactly the situation but it had to do with
sorting or selecting, I think. The plus zero method of correcting
the dates works great.<br>
<br>
I would say that is not possible when a person is putting a date
into a selection set, or index selection option. I try to add to
the field heading the date format required so it is clear in those
situations what to type.<br>
<br>
For example, I might put "Invoice Date (mm/dd/yyyy) ", or "Period
end (YYYYMMDD) "<br>
<br>
I try to make all the dates the same in a project for sanity, but
adding a description to the heading has always helped. BTW -
since filepro knows it is a date edit, it could do that. I just
type a / if I am not sure to see what is filled in, then I correct
it.<br>
<br>
Nancy<br>
<br>
<br>
</tt>
<div class="moz-cite-prefix">On 7/31/2019 10:27 AM, scooter6--- via
Filepro-list wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CADpQzqNnu-RhiocpBvn4kyd-vsSS_kg92V4NL1PiBZYjowmkqg@mail.gmail.com">
<pre class="moz-quote-pre" wrap="">You can always just do
date_field=date_field+"0"
filePro will convert any - to / when you do this
I do this on several input processing fields in @wlf so if any data
inputter decides to be silly and put - it converts them to / when they
leave the field
hope that helps
On Tue, Jul 16, 2019 at 2:58 PM Richard Kreiss via Filepro-list <
<a class="moz-txt-link-abbreviated" href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>> wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">In a date field (8,mdy/) a few entries use a - rather than a slash i.e.
04-18-18 rather then 04/18/18. As filePro excepts the dash- in the date
field, will doedit change the - to a slash /?
If so, how would one write the program line? The date field is field 8 in
the file. As there are only a few (14) out of 839 records, I could either
write a process to update just those records or add the doedit to a lookup
which uses this field.
Lookup filed is kah(8) which sets dummy field ds. Ds=kah(8).
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 11891 bytes
Desc: not available
URL: <
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20190716/fc227612/attachment.bin">http://mailman.celestial.com/pipermail/filepro-list/attachments/20190716/fc227612/attachment.bin</a>
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">-------------- next part --------------
An HTML attachment was scrubbed...
URL: <a class="moz-txt-link-rfc2396E" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20190731/64e5472a/attachment.html"><http://mailman.celestial.com/pipermail/filepro-list/attachments/20190731/64e5472a/attachment.html></a>
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Nancy Palmquist MOS & filePro Training Available
Virtual Software Systems Web Based Training and Consulting
PHONE: (412) 835-9417 Web site: <a class="moz-txt-link-freetext" href="http://www.vss3.com">http://www.vss3.com</a>
</pre>
</body>
</html>