mnthname: autoenter calculation = monthname(getastext(date)) returns NOTHING
isn't there a way to get the calculation to take pLACE immediaitely for all records WITHOUT doing a REPLACE?
there is a difference from a text field with option of auto-enter a calculation
a calculated field, result text.
It seems that you need the last and the calc will be simoly: MonthName ( date )
To emphasize Daniele's last point: MonthName() requires a parameter of type Date. In order to evaluate
MonthName ( GetAsText ( Datefield ) )
it is necessary to perform two conversions: first, the explicit conversion of Datefield to text, then an implicit conversion of the result back to date. All that's achieved here is some redundant CPU cycles, contributing to further global warming.
Thanks for your help. You are right. Changing the field to "calculation" field type updates immediately. As an old dBase programmer I am used to 'doing everything myself programmatically and I guess that habit is hard to break. Thank you again.