JasleenSodhi Member

I agree but you can still use them in charts and it works fine and plots data correctly to the correct week. Do you want to share whats the purpose of keeping the date data type intact so we can think of some other alternate solution?

Hi You can achieve it by below calculation- CONCAT('W',WEEK(`DATE`), '-',YEAR(`DATE`))