Format Question
Doug Luurs
doug at borisch.com
Mon Oct 2 13:08:43 PDT 2006
> -----Original Message-----
> From: Kenneth Brody [mailto:kenbrody at bestweb.net]
> Sent: Monday, October 02, 2006 3:22 PM
> To: Doug Luurs
> Cc: filepro-list at lists.celestial.com
> Subject: Re: Format Question
>
> 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?
Not directly in filepro, but when you Export it as a .SL(k) file, and
Then try to convert the column of Date files, it will not convert
anything with a '.' as a date separator. (- and / works fine).
Guess I'll have to modify the excel outputs with the "Date+0" to
Force the change.
Thanks
> 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
>
> --
> KenBrody at BestWeb dot net spamtrap:
> <g8ymh8uf001 at sneakemail.com>
> http://www.hvcomputer.com
> http://www.fileProPlus.com
>
--
This E-mail, including any attachments, may contain confidential
information and is intended solely for use by the individual to whom
it is addressed. If you received this E-mail in error, please notify
the sender, do not disclose its contents to others, and delete it
from your system. Any other use of this E-mail and/or attachments
is prohibited. This message is not meant to constitute an electronic
signature or intent to contract electronically.
More information about the Filepro-list
mailing list