Forum Discussion
Date format - week.year
Hello,
I have to make a report in which dates must filtered on 16 last weeks. But the format of my dates is:
WeekNumber.Year : 01.2019, for the first week of 2019.
This column format is text and I cannot transform it on date table and also cannot filter on 16 last weeks.
Need your helps !
Thanks in advance
I have to make a report in which dates must filtered on 16 last weeks. But the format of my dates is:
WeekNumber.Year : 01.2019, for the first week of 2019.
This column format is text and I cannot transform it on date table and also cannot filter on 16 last weeks.
Need your helps !
Thanks in advance
1 Reply
Hi Anonymous
You could add extra columns to the data table which splits it up into week and year using the left and right functions.
You can then use these values to filter by the last 16 weeks etc.
Hope this helps
Thanks,
George
