Hello everyone, I have a "Date" column in my database, I have already changed the format I want. Just a problem, when I perform different operations it's as if the display of the date format is visually correct (the one I modified), but the old date format remains active and prevents different manipulations.
Specifically, I want to calculate averages based on months of the year, so my new date format is "YYYY/MM" (Example: 2021/02). While when I realize the average per month, the operation does not work because I suspect the Date format to remain as the old one (Example: 2021020110, "YYYYMMddh24").
Is this normal? And if ever, how to avoid this problem?