Special Date Edit

[Stanley - stanlyn.com]

>> Why not just use a @cd on filePro record as "nearest" date and go with
that as the transaction date thus obtaining a real date?

The invoices mostly handwritten are ancient, coming for old boxes and file
cabinets from many years ago.  Some can be placed into a year as there are
other readable invoices with the problem invoices and its realistic to think
they are from the same year, but that's about as good as it gets, as some
were stored by year, and others were stored by vendor with each vendor file
containing all invoices for every purchase made from that vendor and can
span all the way back to 1970... (hence the poor quality, and believe it or
not, you would be surprised how little info the invoices actually contains,
many with no dates, many with no vendor name, no address, or other contact
info, and mostly handwritten, and from big names like KFC, Phillips66,
PizzaHut and many others)

Thanks,
Stanley




-----Original Message-----
From: Jose Lerebours [mailto:fpgroups at gmail.com] 
Sent: Tuesday, October 6, 2015 3:24 PM
To: 'Stanley - stanlyn.com' <stanley at stanlyn.com>
Subject: RE: Special Date Edit

Why not just use a @cd on filePro record as "nearest" date and go with that
as the transaction date thus obtaining a real date?



-----Original Message-----
From: Filepro-list
[mailto:filepro-list-bounces+fpgroups=gmail.com at lists.celestial.com] On
Behalf Of Stanley - stanlyn.com via Filepro-list
Sent: Tuesday, October 06, 2015 3:06 PM
To: 'Kenneth Brody'; filepro-list at lists.celestial.com
Subject: RE: Special Date Edit

>> How do you expect date math to work?

For sorting, have the missing portion take on a 00 or 0000 if a year.

In other words day and month "00" would be the day or month before "01", and
year "0000" would be the year before "0001"

I fully understand that 00/15/2015 is an invalid date, however I'm looking
for a way that allows entry into a date field and sort before a date of
01/15/2015 and 01/01/2015, whereas a date of 00/00/2015 would sort before
01/01/2015.

Another way of looking at it would be to sort it as a string in
year/month/day order.  Then sorting of these invalid values would be
correct.  

Any way to get an edit to do this instead of treating it as a string? 

It should be noted that I do not like the idea of having invalid dates in
the database, but we have a lot of invoices that needs entered where we
don't have valid complete date info, instead we have fragments and those
fragments which we know to be true needs to be entered into the proper
placeholder, ie. month, day or year part.  Then see those items in a report
along with invoices having good dates and selected as part of a date range.
As a string, 2015/01/00 sorts after 2014/12/31 and before 2015/01/10.

So maybe that is the answer, create an edit in year/month/day order.  Do you
see any issues with sorting, selecting a range, etc.? 

Thanks,
Stanley




-----Original Message-----
From: Kenneth Brody [mailto:kenbrody at spamcop.net]
Sent: Tuesday, October 6, 2015 1:24 PM
To: Stanley - stanlyn.com <stanley at stanlyn.com>;
filepro-list at lists.celestial.com
Subject: Re: Special Date Edit

On 10/6/2015 1:11 PM, Stanley - stanlyn.com via Filepro-list wrote:
> Hi,
>
>
>
> I need a special edit that allows the entry of bad dates AND allows 
> for date math.  For example we have a lot of invoices that portions of 
> the date is unknown like having a missing day part or a missing month 
> part, or a missing year part.
>
>
>
> ??/02/2000
>
> 12/??/2000
>
> 12/15/????
>
> And any other combination,

How do you expect date math to work?

What's the day after "12/??/2000"?

How many days are there between "??/02/2000" and "12/??/2000"?

--
Kenneth Brody

_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list