Next Month Calc

[Bikeman17]

Hi there,

Here is the issue. From a 'date' entered by the user, I want another field to calculate the next month. For example 04/30/2007 should be 05/30/2007.

This calc works OK:

DateToText(Date(Month(date) + 1, 1, Year(date)))

The result is 05/01/2007.

This calc doesn't work:

DateToText (Date (Month ( date ) + 1; DateToText (Date (Day ( date ); Year ( date )))))

The result should be 05/302007 but I ended up with an error message.

any help would be great

[fabriceN]

How about

DateToText ( Date ( Month ( date ) + 1 ; Day ( date ) ; Year ( date )))

?

BTW where is DateToText function ?

[Ender]

Try:

DateToText (Date (Month ( date ) + 1; Day ( date ); Year ( date )))

Keep in mind, for a date like 10/31/07, you'd get 12/1/07 as the result, since there is no Nov. 31st.

[Lee Smith]

GetAsText(data)