Addmonth
Ed Hilovsky
edh at lgfcomputers.net
Wed Nov 4 06:39:14 PST 2015
Yes, you are correct.
Thanks,
Ed Hilovsky
LGF Computers
Main Office: (724) 463-7633
Fax Number : (724) 471-6710
Cellular : (412) 289-1773
On 11/04/2015 9:07 AM, Bruce Easton via Filepro-list wrote:
> On 11/3/15 5:13 PM, Ed Hilovsky via Filepro-list wrote:
>> *System with*
>>
>> Centos release 5.3 (Final)
>>
>> filePro Version 5.6
>>
>> *Simple file:*
>> 1 - Date 8 mdy/
>> 2 - Date 8 mdy/
>> 3 - Date 8 mdy/
>>
>> *Simple Process:*
>>
>> 1=addmonth(1);2=addmonth(2);3=addmonth(3)
>>
>> *
>> **Strange Data from process:*
>>
>> Date: 11/01/15
>> Date: 10/01/15
>> Date: 10/30/15
>>
>>
>> Any ideas why 10/30/15 was returned from addmonth of 09/30/15 ?
>>
>> Thank you,
>>
>>
> That result appears to be correct as advertised. I'm suspecting that
> you want it to return the end of month date. Based on the F10 help,
> addmonth only adds to the month and doesn't change the day UNLESS the
> resulting date would be an invalid date (beyond the end of the month),
> and in that case it would set the day to the eom. To ensure eom for
> any date argument you send through the addmonth function, if that's
> what you're after, you may be able to do something like (using the EOM
> function):
>
> Then: 3=eom(addmonth(3))
>
> (I'm also assuming that fields 1 and 2 in your application apply to
> beginning of month dates and if so, you're already ok with just
> addmonth as long as your argument date is always the 1st; otherwise
> you might need to employ the BOM function.)
>
> Bruce
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
More information about the Filepro-list
mailing list