Calc returns garbled result

[The Wolf]

What am I doing wrong here, it doesn't work? Field payment date is formatted
01/01/2001

Next Payment Due=

DateToText(Date(Month(Payment Date) + 1, Day(Payment Date), Year(Payment
Date)))
--

[Lee Smith]

In reply to BBAD511B.3FCDD%elvispmpsd@earthlink.net on 10/11/03 6:18 AM by
The Wolf [email]elvispmpsd@earthlink.net[/email]:

> Next Payment Due=
>

Date(Month(Payment Date) +1,Day( Payment Date), Year(Payment Date))

Lee

[The Wolf]

On 10/11/03 8:13 AM, in article BBAD6C1E.2ED14%lee@pacific.net, "Lee Smith"
<lee@pacific.net> opined:

> In reply to BBAD511B.3FCDD%elvispmpsd@earthlink.net on 10/11/03 6:18 AM by
> The Wolf [email]elvispmpsd@earthlink.net[/email]:
>

>> Next Payment Due=
>>

> Date(Month(Payment Date) +1,Day( Payment Date), Year(Payment Date))
>
> Lee
>

Thank you! I copied the other one out of FMP5 help. Don't know what was
wrong. Having said that, yours works fine.
--
================================================== =================
"When a broad table is to be made, and the edges of planks do not fit, the
artist takes a little from both, and makes a good joint. In like manner
here, both sides must part with some of their demands," Benjamin Franklin
(1706-1790)
================================================== =================

[Helpful Harry]

In article <BBADEF14.3FD08%elvispmpsd@earthlink.net>, The Wolf
<elvispmpsd@earthlink.net> wrote:

> On 10/11/03 8:13 AM, in article BBAD6C1E.2ED14%lee@pacific.net, "Lee Smith"
> <lee@pacific.net> opined:
>

> > In reply to BBAD511B.3FCDD%elvispmpsd@earthlink.net on 10/11/03 6:18 AM by
> > The Wolf [email]elvispmpsd@earthlink.net[/email]:
> >

> >> Next Payment Due=
> >>

> > Date(Month(Payment Date) +1,Day( Payment Date), Year(Payment Date))

>
> Thank you! I copied the other one out of FMP5 help. Don't know what was
> wrong. Having said that, yours works fine.

Your original calculation was

Next Payment Due=
DateToText(Date(Month(Payment Date) + 1, Day(Payment Date), Year(Payment
Date)))

I'm guessing, but since Lee's versions works I'd say you had the Next
Payment Due calculation returning a Date result.

The only difference between the two is the DateToText function. It was
this which was trying to take the calculated date, turn it into text
and then store it in a Date result field ... not really possible, so
FileMaker displays a ? instead. :o)

Helpful Harry
"Just trying to help whenever I can." :o)