Can you please post your sample data to help you with converting it to real date? Thanks
Hi Ivett, you could use this calculated field to convert that to a date:
DATEADD('week', INT(RIGHT([Date], 2)) - 1, DATE(LEFT([Date], 4) + "-01-01"))
This will basically set all the dates to the same weekday as January 1 of the year; if you don't want that behavior, then we can adjust as needed.