I have inserted a date field into a calculation field and I'm losing a year. The date field is inserted as part of a text string (i.e. "Your "&birthdate&" is..."). In the browse and preview modes the date is displayed as a year less. What's going on here?

Try: DateToText(birthdate)

Tom,

thanks for the suggestion; however it isn't working. The date is coming from a value list. Could that be creating the problem?

jim

Is the field that's using the value list a date field? Are you saying that you can put a date field called "birthdate" on a layout, and calculated text field that = DateToText(birthdate) on a layout and they will display two different dates? Upload the file, I have a hard time believing that.

Tom,

I figured out the problem. The calc field I had created was auto-enter. I guess that must do something to the date that a straight-up calculation field doesn't. Do you know why the auto-enter process changes the year portion of the date?

jim

With an auto-enter calc, if you change the date, then the calc won't update. Are you changing the date at all?

An auto-enter calculation isn't a calculation field at all: it's a method of entering a default value into a "normal" field.

Check the date format applied to the text on the layout.

Jim, if you upload the file, one of us can take a look at it. I suspect it may be related to the field type.