In excell we have a date column set up to auto enter the bimonthly dates, 01/15/04, 1/31/04, 2/15/04, 2/28/04........

I see that under define fields I can set the field to auto enter a value based on a calculation but I don't see a "end of the month" calculation that I can use. Any suggestions?

Still learning

End of Month equals

Date( Month(Status(CurrentDate)) + 1; 0; Year(Status(CurrentDate)) )

Sorry if I wasn't clear, I was hoping to have the field auto enter dates ... If I started with 1/15/04 the next record would auto fill in 1/31/04 for the date, then the next record with 2/15/04, and the next 2/28/04, and so on.

I don't want it to just return the end of the month for the current date.

Thanks

I'm assuming you mean 2/29/04. If so, and you are using 5.5., try this

Create a calculation (or auto-entered if there are currently no records in the file) number field equal to 1 and a self-relationship based on this calc field, sorted by Date descending. Then make your Date an auto-enter calc of

Date( Month(GetField("_::Date")) + 1, 15 * (Day(GetField("_::Date")) <> 15), Year(GetField("_::Date")) )

and leave 'Do not evaluate if all referenced fields are empty' selected.

Could you give me a little more guidance on the calc.

When I set it up it doesn't like the <> and gives a message that a number, text constant, field name, or "(" is expected here.....

Thanks!

See attachment for working sample.

AutoEnteredDates.zip