Insert last mont name and year

[bens]

I need a calc. that insert the month before the current and the current year when a new record is created.

In december it should be November, 2005, and so on.

[comment]

Try:

Let (

d = Get (CurrentDate) - Day ( Get (CurrentDate) )

;

MonthName ( d ) & ", " & Year ( d )

)

The result needs to be text.

Or you can use just this part:

Get (CurrentDate) - Day ( Get (CurrentDate) )

Set the result to date, and format the field to display only the month and the year (the date is always the last day of previous month).

[bens]

Thank you very much, comment