Hi!
I have a select query with a date field in it, let's say a birthdate, and I want to show the field a second time, but then with the name of the month in full characters.
So I made a calculated field in a new column: 'monthname: Month([birthdate])', and it shows the number of the month correctly (ex. '8' for August).
But when I type 'mmmm' in the 'format' property of the calculated field, the recordset always shows 'January' whatever the month really is.
I tried to modify the calculated field in 'monthname: Format(Month([birthdate]);"mmmm"', but this gives the same faulty result as well.
How can I obtain a valid result?
Thanks for your answer, Roger.
I have a select query with a date field in it, let's say a birthdate, and I want to show the field a second time, but then with the name of the month in full characters.
So I made a calculated field in a new column: 'monthname: Month([birthdate])', and it shows the number of the month correctly (ex. '8' for August).
But when I type 'mmmm' in the 'format' property of the calculated field, the recordset always shows 'January' whatever the month really is.
I tried to modify the calculated field in 'monthname: Format(Month([birthdate]);"mmmm"', but this gives the same faulty result as well.
How can I obtain a valid result?
Thanks for your answer, Roger.