I want to create a view based on various documents that have dates attached to them ranging multiple years. I wish to make the first column categorise the view by the dates of the documents but I want the date more generalised than the specific one attached to each document. For example I want all the documents created in the year 1999 to be assigned to the 1999 category and the 2000 documents 2000 etc. So there will be twisties next to 1999,2000,2001,2002,2003,2004 and all documents created in those years will be under their correct year.
Subject: View categorised by date query
Simply categorize using a column formula like:
@Year(@Created)
or
@Year(ADateField)
Subject: RE: View categorised by date query
Thanks.
Subject: View categorised by date query
In response to my own post. I have used the following to extract the year.
@Middle(@Text(datefield);6;4)
Subject: Using text functions to extract a date component is a hangin’ offense in these parts, son.
Not every computer formats dates exactly the same.