problem with eom()

Kenneth Brody kenbrody at spamcop.net
Tue Oct 28 12:57:51 PDT 2014


On 10/28/2014 3:38 PM, Richard Kreiss wrote:
[...]
>>>>> ExpDate=foobar(12){"/01/"{foobar(13)
>>>>>
>>>>> Expect ExpDate = "10/31/2013"
>>>>
>>>> I would expect "10/01/2013".
>>>>
>>>>> In my processing coming up as "10/31/2014"
[...]
>>>> Ok, Ken, I left out
>>> Eom(foobar(12){"/01/"{foobar(13))
>>>
>>> The result should be in year 2013. It comes 2014.
>>>
>>> I just wanted to know if anyone else experienced this problem.
>>
>> The problem is that you are not passing a date to EOM().  Rather, you are
>> simply passing it a string that "looks" like a date -- "10/01/2013".  And, even
>> then, is it "October 1" or "January 10"?  Because you are not passing it a date,
>> you get the EOM of the current date, which coincidentally is also October.
>
>
>> ExpDate = foobar(12){"/01/"{foobar(13)
>> ExpDate = EOM(ExpDate)
>
> Here is an interesting twist to what you are indicating, when I run the same programming in 5.7.4.06, the programming works properly.

Show me the exact code, because the code as posted here will always return 
the end of the current month, regardless of the contents of foobar(12) and 
foobar(13).

-- 
Kenneth Brody


More information about the Filepro-list mailing list