Add a WeekYear column option to the Time Table

When i want TX to create a Time Table, only the Actual year of the date is stored. More specific, '31-12-2012' returns 2012.But since that week also belongs to the first week of 2013, I would like to be able to see the fiscal year in a column as well.


I now add a Custom Field and use the formula:

year(dateadd(DW,7-datepart(DW, [DateValue]),[DateValue]))


Please sign in to leave a comment.