Summary by Year Report?
I have a table with timestamp columns.
I don't see a built-in way, when creating a new layout, to group by year given that I have a timestamp field.
What's the best way to do this?
Add a calculation field that extracts the year from the TimeStamp field. Sort by it to group your records by year.
will extract the year for you.
Hmmm, that's pretty much what I tried.
When I create the calculation field, I added the code you included just to be sure.
In browse mode, that column has a "?" in it.
When I try to group by it, there's no effect.
I've tried making the YEAR(TimestampField) Text, Number, and Date.
It works for me.
I've always used this with a field of type date so I tested it with a field of type timestamp and it also returned the year. According to the help, even: Year ( "11/10/2011" ) should return 2011, so I'm not sure why you are getting the question mark--which is FileMaker's way of saying "I can't display the result". This can be due to a field that is too narrow to display the data or an invalid calculation result such as divide by zero. It suggests here that the value of the field is not a time stamp or date field--perhaps a text field with the date expressed in a format it can't process.
I bet it's an import issue.
It got imported from Excel as Text, but I changed the field type to Timsstamp.
2006-08-24 12:20:29 is an example of one of the cells.
I agree. You may need to manipulate the text into a different format that the function recognizes.
Retrieving data ...