Bug?

[Kenneth Brody]

GCC Consulting wrote:
[...]
> If I am reading the date correctly, it translates to March 29, 2004.
> 
> If this is the case, the 8,mdy/ is reading the date correctly at posted, April
> 3, 2029.
> 
> This is not a bug, fp expects the values to be in the proper sequence.
> 
> You need to use a mid statement to translate the values into the proper sequence
> 
> Cko(4)=mid(7,"3","4"){mid(7,"1","2")

No, you do not.  filePro knows what each part of a date field represents,
and will rearrange it when moved to a date field of a different order.

-- 

+---------+----------------------------------+-----------------------------+
| Kenneth |     kenbrody at spamcop.net      | "The opinions expressed     |
|    J.   |    http://www.hvcomputer.com     |  herein are not necessarily |
|  Brody  |      http://www.fptech.com       |  those of fP Technologies." |
+---------+----------------------------------+-----------------------------+