Format Question

[Nancy Palmquist]

Kenneth Brody wrote:
> Quoting Doug Luurs (Mon, 2 Oct 2006 14:35:01 -0400):
> 
> 
>>Is there a way to change a GLOBAL format (In this case the MDY/ MDYY/
>>formats) to allow only a " / ".
> 
> 
> Those are SYSTEM edits, not GLOBAL edits.  System edits are built
> in to filePro and cannot be changed.
> 
> 
>>Right now, I have a few people that have a bad habit of using " . " in
>>the place of " / ", and it messes up a few things on occasions.
> 
> 
> How, exactly, does it "mess up" things?
> 
> However, if you need to force a "/" separator, you can use @WLF on
> the date field and add zero to the date, causing filePro to put
> slashes in for you.  For example:
> 
>     @wlf5  If: 5 ne ""
>          Then: 5 = 5 + "0" ; display
>            If:
>          Then: end

Ken & Doug,

I had issues with Dates that were entered with / or - in trying to find 
matches in an index or doing comparisons.  The solution suggested above 
helped force all dates to the same format and made outputs more 
consistent.  It might be a great function if a date edit allows other 
characters as separators why doesn't it change them automatically to a 
slash, whenever a separator is indicated?

Like a phone number it would look much better and be somewhat automatic. 
  Also it might be useful to offer an ENVIRONMENT option to set the 
characters.  I am seeing more and more dates with periods and it might 
be nice to conform all to the same symbol.

Nancy


> 
> --
> KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
> http://www.hvcomputer.com
> http://www.fileProPlus.com
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> 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