doedit

[Nancy Palmquist]

Scooter,
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 /.
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.

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.

For example, I might put "Invoice Date (mm/dd/yyyy) ", or "Period end 
(YYYYMMDD) "

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.

Nancy


On 7/31/2019 10:27 AM, scooter6--- via Filepro-list wrote:
> 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 <
> filepro-list at lists.celestial.com> wrote:
>
>> 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: <
>> http://mailman.celestial.com/pipermail/filepro-list/attachments/20190716/fc227612/attachment.bin
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20190731/64e5472a/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>

-- 
Nancy Palmquist         MOS & filePro Training Available
Virtual Software Systems    Web Based Training and Consulting
PHONE: (412) 835-9417           Web site:  http://www.vss3.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20190731/378a2465/attachment.html>